Need a Macro to combine 1-5 sheets in one sheet

[showry]

Hi All,

I have a 5 sheet workbook with different no.of columns(Max 20) & rows
(but max lines 1500) in each sheet but all sheets contains "A"row
unique code. that code should not repeat in all 5 sheets. I need a
combination of 5 sheets data into 6th sheet with accending codes.

for ex:

in Sheet1 the code contains 1,2,3,5,6,7,9 but in Sheet3 code contains
4,10,12 etc. in sheet3 8,11,13 etc
but in sheet6 i need a codes and its info
1,2,3,4,5,6,7,8,9,10,11,12,13 so on..


Pls Help me.


Regards,
Anil.

 

[Don Guillett Excel MVP]

Hi All,

I have a 5 sheet workbook with different no.of columns(Max 20) & rows
(but max lines 1500) in each sheet but all sheets contains "A"row
unique code. that code should not repeat in all 5 sheets. I need a
combination of 5 sheets data into 6th sheet with accending codes.

for ex:

in Sheet1 the code contains 1,2,3,5,6,7,9  but in Sheet3 code contains
4,10,12 etc. in sheet3 8,11,13 etc
but in sheet6 i need a codes and its info
1,2,3,4,5,6,7,8,9,10,11,12,13 so on..

Pls Help me.

Regards,
Anil.

A looping macro to get the data from each sht and append to the last
row+1 of the desitination sheet and then sort the destination sheet.
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."