Generally, you rarely export tables, you export queries. So store the week info in the table, then have the query filter for whatever week you want (but don't include the week ID in the SELECT clause, only in the WHERE clause.)
Renaming tables is possible but tends to break relationships AND/OR require you to rebuild new relationships.