Obtaining Sheet Name

[jamesstorx]

Hi Guys,

I am trying to compile all the data from multiple workbooks into one worksheet. The problem that I have is that the worksheet name is never the same. There is always 1 sheet in the workbook, but I can't seem to get the sheet name that is variable to be in my code? I can find examples where people have gotten the sheet name in a cell, but that's not what I am looking for.

Thanks for any help.

-James