Make a dynamic 'sheet' active to be able to extract data into an array.

Hi All,

Firstly thanks for help in advance, people in this forum are fantastic

My issue is as follows:

I'm trying to copy data into an array from various workbooks and then put said data into another set workbook. My source workbook has 3 SET worksheets which do not vary meaning getting data from these is perfectly fine and I've accomplished this task.
However, AFTER these sheets there are other sheets with info I need on however they're always named differently in each workbook. This can range to 1 extra sheet or 10 extra sheets.

An example would be that my Source workbooks may have sheets called:

A, B, C Then 54, 59
A, B, C Then 99, 101
A, B, C then 12, 84, 59, 78
etc

I can take any info from sheets A,B,C on any workbook however Its navigating to the data on the dynamic worksheets I have issues with.

The only solution I can think of is that on those dynamic worksheets, there is ALWAYS the same Headers so perhaps I can do something along the lines of:

Please Login or Register  to view this content.

Any ideas?

Thanks In advance, this ones a toughy!!

Hi Admin, Apologies I tried to edit my original post and accidently created a new thread,

Please delete as it's a duplicate

Again, apologies