I am trying to obtain data from multiple worksheets:
Where: sheet 1 - has an F2 cell that enables you to choose from a drop down list of names and each of these names equals a different worksheet in the one workbook
sheet1!b2 is a cell that enables you to choose from a drop down list of colours that you will use to search the F2 cell selected worksheet
sheet1!h5 is a cell that meets a month criteria
F2 selected worksheet cells are: d4:d36 are the cells in the worksheet selected through f2 where I want to add the data that matches the colour in b2:b36 on the same worksheet
a1:aa1 are date fields on the f2 selected worksheet that meet a further sort field on the initial sheet 1 at h5.
Hope this makes sense.
I keep getting a #ref error but do not know why?
=SUMIFS(INDIRECT(F2&"!d4:d36"),INDIRECT(F2&"!b2:b36"),Sheet1!B2,INDIRECT(F2&"!a1:aa1"),Sheet1!H5)
Any help would be appreciated.