INDEX and MATCH formula in a macro

The formula I'm working on is a INDEX and MATCH formula with two variables and operates from data across to worksheets in the same workbook

First question: the range is wrong and I don't know what to do to correct it.

marco index & match.jpg


Second question, after I fix the range, how do I make this formula work across multiple columns and rows in the sheet?

Here's an example of the formula in Excel. I need this formula to operate in columns B-P and rows 2-60.

formula in excel.jpg

The reference cells need to change as the formula moves from left to right and top to bottom