How to merge two sheets in a file?.

[Happy New Year]

Hi! I have a file with two sheets (tabs). I would really like to have all the information in one sheet, but can´t figure out how to make the first sheet the first page of my doc. Would appreciate the help. Thank you

.

 

[Macropod]

Hi HNY,

Is there a reason you can't simply cut & paste the second sheet's data onto the end of the first sheet?

 

[navb]

Hey. I have somewhat similar query. Will be great if someone can help or atleast point me in the right direction. I have somewhere around 25 similar workbooks which I want to merge in a single sheet. I want to do this without opening any of the workbooks as this will save lot of time. Can this be done ? I have heard you can do this by using some ADO connection and then querying the excel database but dont know how to do this. Any help will be greatly appreciated !!