You can use INDIRECT() to construct a sheet/cell reference using pieces of text strings. When the construction is complete, INDIRECT converts that to a real link and brings back the value from that cell. You Database sheet is already setup perfectly for this, though the name "database" is ill-advised.
A DATABASE is usually a source sheet from which OTHER sheets are created, not the other way around. In this instance I'd call the front sheet "SUMMARY" or something like that. Then ALL the pieces of information including ID number and DOB should be on each person's individual sheet, 1, 2, etc.
The formulas for your current setup would be:
B3: =INDIRECT("'"&$A3&"'!F3")
C3: =INDIRECT("'"&$A3&"'!F4")
H3: =INDIRECT("'"&$A3&"'!E11")
If you put the missing ID and DOB onto the sheets 1 and 2, you can put similar formulas into D3 and E3.
Then copy the formulas in B3:H3 down.
Bookmarks