Creating a table to accept Data Base data

OK - This title will definitely have to be changed. But I'm not sure to what.

So...I have this workbook with a lot of proprietary data in it that summarizes open job orders, job orders that were gained during the previous week, assignments made, assignments ended, job orders closed....I think that's it. So the first sheet is a summary page that graphically shows all of this information. Each category (Open Orders, Assignments Made...etc) summarized on the summary page pull from a data sheet in the same workbook. So that all of the details can be seen about the data each data page also has a pivot table that was created on another sheet. There are hyperlinks all over the place so that folks can easily navigate.

Here's my question:
The data sheets were orginally fed by the copying of a report from a database and pasting it into the sheet. i then formatted the data into a table. The table is important at this point because all of the formulas on the summary page point to columns in the table. The data is now being pulled into the data sheets via a macro written to interogate our database for the information needed. The report will run every Monday. What I'm worried about is if the new week's information goes beyond the range of the "table" will the table expand with the data. When I would copy and paste the table would expand but I'm not so sure it's going to do it now. I tried formatting A1:N4000 as a table but the table always retracts to where the data stops.

Any ideas?

Hi Cjax
Are you using the new "Tables" implementation in Excel 2007?
One of their characteristics is that they do expand intelligently as new data rows or columns are added.
So the answer to your Q is Yes.
barry