I am using the following formula:
=VLOOKUP(ROW()-1,Formulas!$D$2:$BK$501,51,FALSE)

I'm trying to figure out a way to not hardcode the column letters and the
col_indx_num. I have added two rows to each sheet with the information I
need. If the letter D is in A2 and the number 51 is in A3 how would I write
that into my formula?

Detailed information below - As a better way to do this would be appreciated.

I have to copy this formula into 10 columns for each sheet and I have 50
sheets.

Each time I copy it on the same sheet form column to column I have to change
the col_indx_num and then when I copy it to a new sheet the col_indx_num
changes for each column by -1. I also have to change the $D to $E and so
forth.

On my formulas sheet I have information setup so each sheet does it's look
up starting with the left most column first from column D for sheet1 and then
from column E for sheet2. The information it returns are all in the same
column but because I am changing the first or left most column it changes the
col_indx_num

Very time consuming. Any help will be appreciated.