Combine two spreadsheets using Macro
 

I would like to combine two separate spreasheets into one larger spreadsheet.
The only common data field on the two sheets is a store number.

What is the easiest and most efficient way to do this in Excel?

I tried to use MS Query, but my data field is too large.