How do I get data into a worksheet from two seperate sources within the same
workbook. I have two worksheets only one of which will contain data in a
given setting but there is no way of telling which one at the time of setting
up the file. I need a formula that will fill in the sheet in question based
on the data in any one of the two sheets.

The formula that I use to get it form the one sheet is :
='Gradebook - 15%, 65% & 20%'!D7*D6/100

The other sheet has the same name except the pertages are different, the
cell refs are the same. Essentially i need the upload file that I have
created to gather data from either one of these, but i wont know which one
has the data at the time of creating the workbook.

Any assistance would be great

Brian