=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!