Greg didn't copy across enough columns... and you'll need an extra column for week number, but his suggestion is the only practical way to go. Sorting out 52 different data blocks would be pretty much impossible for a formula to cope with. One big long table will work just fine, with filters.