Hi JaBob,
I have here an example of some Excel codes I have worked on before. You may find it useful. I use the ActiveX (under Function Pallete - Communication) to work on Excel. There maybe other better tools such as the Microsoft Office Report Generation Toolkit which is simpler to use and it is an add-on by NI. You will need to buy from them.
Please have a go with it. As for all the sheets to be displayed, I have yet to do that. But what I have here for you is reading a range of data and display onto the table.
Hope you can understand my codes,
Regards,
juni