I need the weeks seperate to return weekly results.
No you don't. If you keep everything in one sheet, you can use AutoFilter, Advanced Filter, Pivot Tables, formulae to select subsets of data. None of which you can do if you spread your data over an arbitrary number of worksheets.

Regards, TMS