Hi all,

I input data into a workbook at the end of each week with each worksheet representing the entire week (Monday through Sunday). I have about four weeks worth of data with each week on its own worksheet (the worksheets are the same, based off of a template I created...I just plug in the data and move on).

I would like to have a master or summary sheet that captures individual sections of data pulled from each respective worksheet and for it to be able to auto-update when I add a new worksheet (i.e., when adding a new week into my workbook). This way I can see a cumulative average or sum of a specific section of data.

I was messing around with the =VLOOKUP function and naming data ranges from a specific worksheet, but can't seem to figure out how to add a new worksheet that will update the master sheet automatically.

What is the most efficient way to do this?