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
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:
Thanks In advance, this ones a toughy!!