Hello

I have created a series of time analysis spreadsheets in which users input time against pre-defined activities. I now need to consolidate the information preferably using sumproduct. Sumproduct is done on the activity name and total for each week. I have created one column per week per user in the consolidation.
I think I need three cells to input the variables to capture the source data being 1) the path containing the files 2) the filename (each user has their own file) and 3) worksheet name which varies according to the week for which activity is being input.
I presume I need to use the INDIRECT function but am struggling to combine this with the concatenate of 1, 2 & 3 above.

Thank you in anticipation