Automate Master Sheet

Occasional Visitor

I have a workbook that contains 9 worksheets plus a Master sheet, all have tables I need the data from the 9 worksheets to update the Master sheet without using vba or macros. I used the vlookup formula on the master sheet but doesn't self populate.

1 Reply



If you are able to share either the actual workbook or a facsimile (not an image, an Excel workbook with false data), it would be a LOT easier to see exactly what you're working with.


If you're not able to do that, a question and suggestion:

  • Are the 9 worksheets laid out in the same fashion? If so, you might find the INDIRECT function helpful -- I use it in a similar situation, to extract data from subordinate sheets to a summary master, where all of the subordinates are arrayed similarly.
  • Here's a useful reference on INDIRECT: