Macro to populate summary sheet

Hi,

I am trying to crate a macro to populate a summary sheet so that I can compare several Publishers results together. (see attached file).

Within the summary sheet the columns starting "400" all denote a publisher who has their own sheet within the workbook. All of the publishers sheets follow the same layout exactly.

I need Cell B3 to populate from the last cell (with data) in Row 10 (of that respective pubs sheet)
I need Cell B4 to populate from the last cell (with data) in Row 11(of that respective pubs sheet)
I need Cell B5 to populate from the last cell (with data) in Row 12(of that respective pubs sheet)

If somebody could get me this far I can certainly do the rest myself.

Many thanks for any and all help.

Cheers

Jon

Watersev.

That is excellent, thanks so much,

One small glitch is that if a row is empty except for the header column in row A, the summary sheet populates as the text of the header row.

How would I get it to ignore Column A and if a row is blank either populate nothing or '0'?

Cheers

Jon

the code has been amended, please check it out