If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

If you've created multiple spreadsheets that contain the same data columns, you can combine their contents into one Access file by repeating the data-import process with each individual spreadsheet.

Notice that the spreadsheet contains data on three companies; each has different asset classes that were placed in service over a period of three years. Imagine what you’d have to do to manually ...