If the first rows of the two worksheets are headers you could use ADO
and a select statement to merge the two Worksheets.

No formatting to worry about.

Read the thread : "How do you store data in Excel as a database?" for
examples.