Hello all-

Is there a way to link several worksheets together to a master worksheet, so that when you update one, the master worksheet will be updated?

An example, so you will understand what I need: Lets say that I receive a spreadsheet from each of the divisions every month with current job candidates for positions in their respective divisions with the names of each candidate, schooling, and other information. Each month, the divisions send me an updated list. The changes to these updates may not be just additions to the list; they could be removals, additional information added to a name already on the list, or updated information for a name already on the list. Ideally, I could copy/paste the updated worksheet for each division each month, and it would automatically update my master worksheet.

So the end result I would need is a master worksheet that is simply a compilation of several other reports that auto-updates whenever any of the linked reports is changed (the columns on each report would be identical). This would include rows being added or taken off, so I can't just use a simple =[cell_range] formula, because if I then added a row to the referenced workbook, the new row would not show up on the master report. An added complication is once I have figured out how to make the master worksheet auto-update even when I add rows, figuring out how to make it so that when a new row is added, it would not delete the first row of the next report that is consolidated on the master sheet.

Obviously I could just copy and paste the new divisional reports each month/week/whenever I get them into a master spreadsheet but there are two problems with this...1) I have several reports that require a similar task in addition to the example I have just given, so continuously copying and pasting these reports that get updated can get tedious and time consuming. 2) The divisions don't always send me a full updated list; instead, they might send me just the updates. This means that if I want to keep a divisional report and a master report separately, for each change, I have to either go find the changes to be made in both the divisional worksheet and the master worksheet, or make the changes in the divisional worksheet, and then make a new master report by copying and pasting the updated divisional worksheet and all the other divisional worksheets into new master report.

I'm hoping that being able to link worksheets to autopopulate a master would minimize both the time spent updating the list, as well as the potential for human error

Is there any function (including any macros that might work) where I could do this?

Thanks!