I have a woorkbook with multiple sheets (100+) which I need to analyse. I
need to combine all the worksheet data into one worksheet to be able to
manipulate.
All worksheets have the same table format but all contain different numbers
of rows. I will receive a different report each month from which I need all
the worksheets combined but each time there may be a different number of
worksheets and a different number of rows.
Is there a way to combine these into one 'lump' of data??
Thanks