combine several books in one

[mr.remizov]

Hi, help me, please, to combine data from the books in one book, consecutive. (.Row + 1)
That is data of book Koroner, book Smith and book Solomonov (A2:Q) to move in book General

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

You may have to adjust/modify the sheet names.

[mr.remizov]

JOHN H. DAVIS, names sheets changed, does not work, It must be so.
As a result of book general has to be such

[davesexcel]

Just an update version of JHD code using sheet(1) instead of a sheet name.
It would also be accurate to say to just have only the workbooks open that you want to get the information from.

Please Login or Register  to view this content.

[mr.remizov]

davesexcel, Yes, it works, thank you very much