Hi!
I have 10 worksheets, each is named for the company we manage.
B380 - B435 are the different payment methods
Columns H - S are YTD total, balance and the months of the year starting with July

B C D E F G H I J K L M..... S
380 OCA Amount YTD Paid Balance July Aug Sept Oct Nov Dec
381 MHA18 10000 5000 5000 1000 1000 1000 500 500 1000
382 MHA70 20000 10000 10000 2000 2000 2000 1000 1000 2000

all the sheets have the same set up in the same rows and columns.

in Sheet 11 (payment summary)
I want to create a summary of payments for the specific month.


July Abriendo Agape Banyan Camillus CARE Carrfour Catholic CFCE CHI Citrus C-FACT Concept CTC
OCA
MHA18 1000
MHA70 2000


this formula works with indirect reference to the row, sheet name and the specific column, but I would have to manually update the column every month (the R6) cell.
VLOOKUP($A31,INDIRECT("'"&E$17&"'!A386:T395"),$R$6,FALSE)

Since someone else will be using the worksheet, I would like it to be dummy proof so he doesn't mess this up.
I want to so that the top corner where is says July, if I updated that every month to the corresponding month name, the values will change automatically.

I figure there is an index/match function but not sure how to include it.

THANK!!!