How do I get the sheet name?
 

Hello,

I am importing specific information from CSV files and I
want to get the sheet name for each file that I open so I
can use it as a heading in the workbook that I am
compiling the information in. How do I do this?

Thanks,
Jeff