Based on tab label name in the beginning

[Jerseynjphillypa]

I am using the following code below for one excel file

Please Login or Register  to view this content.

But when I copy the Macro to another excel file, instead of Table, it is List

Please Login or Register  to view this content.

is there any way to tell the Macro to only look for the tab label as "_003" in the beginning and NOT telling it to use the active sheet.

Since with my Macro i have it creating Pivot tables and charts

[nilem]

maybe something like this

Please Login or Register  to view this content.

[Jerseynjphillypa]

Thanks for your help nilem.

I keep getting an error (highlighted in red) when I replaced the code with yours, but I'm just trying to create a pivot table now

Error: Invalid procedure call or argumment

Please Login or Register  to view this content.