Hello everyone,

I hope you are all well and will be able to help me a bit.
I'm new to formulas but I am hoping that if someone helps me with this one i'll be able to do the rest and learn faster.

I'm trying to create an index spreadsheet that sums all of my sheets.

I have a list of residents in cells I5:I52 with range name defined as "Residents"
Each resident name has its own spreadsheet
Each spreadsheet in cell B2 has resident name
Each spreadsheet in cell G5 has residents weekly fee

What i'd like to do is to lookup residents weekly fee found on G5 of each spreadsheet in cell A5 of the index spreadsheet, if B2 across all spreadsheets equals residents name.

Can someone help me please.