Index Match / VLookup to reference Worksheets

Hi All,

Is it possible to use Index Match or VLookup to first determine which worksheet to look at, before then finding a value using a second criteria. By the way I know how to use Index Match to look up using multiple criteria, the only thing I need assistance with is the worksheet aspect.

For example and with reference to the attached, I have a summary table on the tab 'Summary' which lists pertinent data (totals) from each of the other tabs. Each of the other tabs in this case represent a month and all contain one row for each day of that month. Each of these daily rows is used to denote the level of activity that took place on that day. The total of the monthly activity is also contained on the monthly worksheets. The pertinent data (the monthly totals) should pull through to the summary table.

For example, with reference to the attached, cell C3 on the Summary tab should show the total apples delivered in January. This information can be found on the Jan-16 worksheet in cell C34 and so on. Rather than manually linking the summary cells to the respective cells on each monthly worksheet, I would prefer to have an INDEX MATCH function on the summary sheet which detects which monthly worksheet should be referenced, according to the data contained in column B of the summary tab. Then, once this information has been determined, then the formula shall carry on as normal by determining which total to pick up e.g. Apples, Pears etc. based on the data in row 2 of the summary tab