I I am created a table that references the exact values of cells in a different table. I have to drag this formula right 100 cells, so it will be tedious to input these manually.

Example:

New table created in column P & Q, referencing data in a table in columns A through N.

P39: '=D4' Q39: '=I4'
P40: '=D5' Q40: '=I5'
P41: '=D6' Q41: '=I6'

Thanks in advance.