Combining multiple sheets into one

[[email protected]]

Hi

I have a shared workbook which has data added to two separate sheets by
two separate users. I need to combine this data into one summary sheet.
Each day, each user will enter a variable amount of records for the
day, and I then need to merge these two day's worth of data into one
sheet.

All the functions I can find seem to actually match and merge the data
together, wheras I want to keep all records and data, but just combine,
say, 25 records from sheet1 and 32 records from sheet2 to 57 records on
sheet3.

Any suggestions?
Thanks
Pete

[davesexcel]

just tagging along, I have the same question