Hi, I'm looking for a way to get data from a workbook and automatically extrapolate the data onto another work sheet. The workbook consists of sheets by month and each month has certain companies and how much they are paying. In the automated worksheet, all it has to do is get the data from the various monthly sheets in the other workbook and update as those monthly sheets update.

Is this possible? thank you