As reference, here is the formula I am working with;

=IF(A8='Master Data'!D2,'Master Data'!E2,IF(A8='Master Data'!D3,'Master
Data'!E3,IF(A8='Master Data'!D4,'Master Data'!E4,IF(A8='Master
Data'!D5,'Master Data'!E5,IF(A8='Master Data'!D6,'Master
Data'!E6,IF(A8='Master Data'!D7,'Master Data'!E7,IF(A8='Master
Data'!D8,'Master Data'!E8)))))))

The 'Master Data'! D2 - E2, E3 - E4 and so on...are based on a table that I
built on a separate worksheet. This formula is located in cell C8. When I
copy the cell and paste it to cell C20, my formula looks like;

=IF(A20='Master Data'!D14,'Master Data'!E14,IF(A20='Master Data'!D15,'Master
Data'!E15,IF(A20='Master Data'!D16,'Master Data'!E16,IF(A20='Master
Data'!D17,'Master Data'!E17,IF(A20='Master Data'!D18,'Master
Data'!E18,IF(A20='Master Data'!D19,'Master Data'!E19,IF(A20='Master
Data'!D20,'Master Data'!E20)))))))

While the A20 in the formula is good...I need 'Master Data'!D2 instead of
'Master Data'D14.

Are you confused yet?