How to dynamically apply the Row and column name

Hi Team,

In excel macro, I have created a function which takes the data from another excel sheet and assigned it into table. Currently I am giving hard coded values into the Cells(row, column keyword. Now I would like to dynamically assign the Row and Column number values into the variables on the basis of any particular keyword, from where counting can get start.

For more details please refer the attached spreadsheet and help me to create such formula. Thanks!