Everyday I get new data that goes into a new worksheet. These worksheets tabs are named according to the date (month - day - year, example 12-20-2010) and only days that are business days get an assigned tab (holidays and weekends excluded). I then have a table that takes the average of each cell over the last X number of tabs / business days (X is a value in a cell - say 30).

So I need to average specific cells over the most recent X tabs and I can't figure out how to do this.

Any input would be greatly appreciated.