Wildcard on tab name to copy data

Hello,

I have a looper file with code that says find this tab go to it copy the data and bring it back to the looper macro. It does this over and over stacking the data together for analysis. There is 120 files for me to loop through. The problem is the users of the file in half the cases changed the tab name. Is there a way to modify this code so that it uses a wildcard to find the tab and pull the data? See the code below.

Some tab names are "Periodic_PA_PY_Commentary" others are "Periodic_PA_PY_Commenta_1" I tried using the wildcard in the code below but it debugs on the line with the wildcard in it.

Please Login or Register  to view this content.

I think i figured it out. Use the codename instead.

wkbTarget.Sheets(2).UsedRange.Copy