Each month I receive a workbook with approx 70 wkshts in it. These
sheets are never in the same order and the sheets are only numbered "sheet1"
etc. The sheets are then identified and copied into one of seven existing
wkbks (each with approx 10 wkshts).

The 70 worksheets are identified because A1:A5 give details i.e. A4 or
A5 names the wkbk it is to be copied into and A2 or A3 names the actual
wksht it is to be copied to.

Could anybody help with this problem, indeed is it do-able

As I see it, I need to

Open one of the 7 existing wkbks as well as the new 70 sheet wkbk.
Ask it to compare page 1 A1:A5 with each of the 70 wkshts until it finds a
match.
Then copy the found sheet, back to the original (existing)
Then move to the next page and repeat until all 10 sheets from the 1st book
has been found.
Then open book 2 and repeat .

Any assistance gratefully received,

Bob