We have a software system on our server that contains our company data. I
have created reports using the Table wizard in Excel that accesses this data.
The data gets dumped into "Worksheet 1" and I have formatted the cells in
"Worksheet2" to refer to the corresponding cells in worksheet 1 and be
displayed as a dashboard for executives.

Its all fine for the current data..but when I run the reports and "refresh"
the data from the server, the new data gets dumped correctly into Worksheet
1. However, the data in Worksheet 2 shows #REF! error.

(Row 5 is the header for both worksheets.. and the data startes form Row 6.
worksheet2 Row 6 refers to Worksheet1 Row 6 and so on.).. when the new data
comes in, the top rows below the header in Worksheet 2 displays the #REF!
error and that cell does not refer any cell =Worksheet1#REF! )

Please help!