[Andante]

If you want more data shown in the song list, you will need to change the Title Formatting. Settings > Library Settings > Piece (or Song) Title Formatting. This allows you to control what is displayed in the title and subtitle areas for the songs.
This will only show metadata that has been added to songs in mobilesheets. And it will show all entries for a field.
To add metadata there are several options:
1. The most basic is to import a song, manually fill out some of the data in the import dialog, then finish adding metadata by editing the song. You will have to do this sometimes.
2. Use PDF bookmarks (if the PDF file has bookmarks) during import to generate songs and add some metadata for them.
3. Create a csv file. Use a spreadsheet program to fill out the metadata. The first row must have labels that mobilesheets can detect. After entering the data, the spreadsheet needs to be exported as a csv file with commas or semicolons between columns of data. I ended up making a Google sheet to make it easier for me to make a properly formatted and organized csv file. A copy can be downloaded here. https://www.zubersoft.com/mobilesheets/f...-8745.html
Once the csv file has been used to generate songs with metadata, the csv file is irrelevant to mobilesheets. Any changes to the csv file will not show up in mobilesheets unless the songs are deleted and reimported. The import dialog box does show the mapping for the csv file columns to the mobilesheets fields so you can check it.
4. If you have your individual song pdf files in an organized directory structure, you can use the 'Populate Metadata from Directories' option in the batch import.
Once the songs (and data) are imported to mobilesheets, the only ways the change the data are via the song editor or by deleting and reimporting.

Thank you for your detailed, logical response and the words of warning " Any changes to the csv file will not show up in mobilesheets unless the songs are deleted and reimported . Once the songs (and data) are imported to mobilesheets, the only ways the change the data are via the song editor or by deleting and reimporting."

Your
(1) Is how I started just to get a feel for the program with single PDFs for one piece of music.
(2)None of my PDFs have bookmarks as I assumed giving an accurate range of pages in the format (number hyphen number) would suffice 
(3) I did that with column headings.
(4) All my PDFs are in one directory so I will now separate the individual song PDFs from the bunch and create a separate directory for Batch Edit - nice tip.

I'm beginning to think that Excel does not make a good job of CSV files as itsme recommended Libre calc and you recommend Google Sheets.

Start again will be myapproach and try to get the 'template' right. Then focus on the Title Settings as you indicate.

Once again I really appreciate your help and everyone who has responded. Much obliged.