Your table should have a field that identifies the batch (week) of data - by date or whatever. Then each week when you append your records you would also insert that identifier data. I would not
a) over-write this table every week as a new table (a make table query)
b) rename this table every week regardless of how the data is input
I would run either an append query as I mentioned, or if I only wanted data pertaining to a particular period, I'd run a delete query on this table before running my append. This all presumes you're using a query rather than some other type of data import. You didn't say how you were inputting the data although I suppose you might have an import specification, according to what you wrote.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.