I want to set up a spreadsheet that Sheet 1 will be information on a number
of subjects. I then want to have a sheet for each subject separately. Can I
link the cells pertaining to each subject in Sheet 1 with the sheets per
subject. Can I link the cells per subject all at once by highlighting the
cells I want linked in the subject sheet enter the = sign and then highlight
the cells in Sheet 1 to link them to each subject sheet.

Thanks in advance for your help.

Best regards,

Dee