Merging Spreadsheets with Identical Columns

Hello All, am trying to do something easy here but in preparation of a high volume, want to automate this merging process. I will have multiple spreadsheets, let's say 10 as an example, that will contain the exact same columns (fields), however each will have different data on the rows. So worksheet 1 could list 15 employees and their information such as ID, rating, location, etc.; worksheet 2 might have another 20 employees listed; worksheet 3, another 25 employees; etc. Each worksheet would represent a department within an organization.

At any point in time, I will need all information merged to show the list of the full organization, which today would mean either copying/pasting information from each spreadsheet to a master spreadsheet, or more likely using a basic macro. In this case, because I am looking for the master spreadsheet to update via links (using Office 365 OneDrive), am wondering how to best merge/consolidate these spreadsheets so that an update on worksheet 1 for example would automatically update the master spreadsheet.

I tried using the consolidate feature in Excel, however I am not looking to calculate (sum for example), or remove duplicates as there will be no dups. Rather, I am simply looking to have all information put together on one spreadsheet, and again, automatically. The Consolidate feature also added 'groups' which in my case is also not needed.

Am hoping I am missing something easy here and looking for any suggestions or added insight. Thanks in advance for any help !

Sheryl

You could do it with a few formulae. Here's a couple of threads from the last 2 days in which I show the OPs how to do it from 2 sheets into one Master sheet:

http://www.excelforum.com/excel-form...-a-master.html

and:

http://www.excelforum.com/showthread...40#post4544540

Hope this helps.

Pete

This was quite educational, thanks so much for sharing. This can work well, only challenge I am still having is enabling external links (due to using multiple spreadsheets) so I will have to work through that. Thanks again.

Sheryl