Helped needed to index match row header, column header, and sheet

Hi

This is my first time posting here, I need some specific help on matching different row column and sheet name (I keep getting error returned if I try to combine too many formula)

On the attached image, Master Sheet has categories in row/column, state header and Month header

I want cell B4 of maste rfile, to return the value from individual sheet state name (matching Row 1). where in the sheet, column A have same row header, A4 (Master). row 2 with same column header "B3" (Master) and row 1 with same month code A2 (Master)

I currently use index match to return with this portion (column A have same row header, A4. row 2 with same column header "B3"), but our actual file has all states and numerous categories that I fear manual change on different columns may cause error, would it be possible to have a formula that return with the above criterias?

Thank you sooooo much for your help! (The attached image portion was a bad screenshot which I can't figure out how to remove)

Master File
Master Sheet.PNG

Individual Sheet
Individual Sheet.PNG

This assumes that the sheets are in the same workbook. In cell B5, use the formula:

=INDEX(INDIRECT(B$1 & "!A1:ZZ100"),MATCH($A5,INDIRECT(B$1 & "!A:A"),FALSE),MATCH($A$2,INDIRECT(B$1 & "!1:1"),FALSE)+(MOD((COLUMN()-2),3)))

And copy to all the other cells where you want data. If you have more than 100 rows of data and 702 columns, change A1:ZZ100 to accommodate your actual data sets.