Ok, I will try to make this as uncomplicated as possible.

I've got 3 worksheets, each with key information in cells B6:C13 and
B28:C35. The data on each sheet is updated (and overwritten) on a monthly
basis, with the relevant date being displayed in cell A1.

I now have a summary sheet which needs to extract the information from the
cell ranges shown above, with the ranges from sheet 1 being displayed first,
the ranges from sheet 2 displayed underneath and finally the data from sheet
3 displayed at the bottom.

The data in the summary sheet is organised by month, the idea being that
once the original 3 sheets have been updated, the relevant data is extracted
and recorded, thereby maintaining a log of how each company is progressing
throughout the year.

Is there a way to copy the relevant data (whether through vlookups or
copy/paste) into the summary sheet where cell A1 on each of the original 3
sheets matches the relevant month in the summary sheet?

In theory the next available block of cells to record the data will reflect
the relevant month.

Any help, or any suggestions as to how this might be made easier, would be
gratefully received!

Thanks in advance.