Formulas change when data is updated

Windows Excel 2007
XP SP 3

I have a workbook which is loading data from an web server. Its set up to load whenever the the file is opened. I use the first sheet to display the "raw data" from the datafile.

I use a second sheet to "Tabulate" the results. I have set this sheet up to get the data from the first sheet. so I have formulas in cells on the second sheet like this:

='Raw Data'!A8
='Raw Data'!A9

etc...

When new data is posted and the workbook is opened, the new data is populated onto the raw data sheet like expected. However, only the last cell that was previously populated with data get populated with the new data, and then, its the last line of new data that is there. So, if there was 3 new lines of data, only the third ones gets populated into the cells.

The formula in the cells on the Score Sheet then look something like this:

Cell A8 ='Raw Data'!A6
Cell A9='Raw Data'!A7
Cell A10='Raw Data'!A11

Can someone give me hint as to whats going on here?

Thanks
-kaz

**EDIT** Well, for what its worth, I found the issue. I had to go to the "Data Range Properties" and select "Overwrite existing cells with new data, clear unused data". Works now.