Mergining excel spread sheets

Does anyone know how I can merge two seperate spreadsheets, but still keeping their own formatting, ie seperate headers and footers, and page sizing.
Thank
Joe