Assuming the week numbers are on one row and the relevant data for each week is in the same column, below the relevant week number, then use a series of HLOOKUP() functions.
These can be used to return data from the selected week number column, in the entry sheet.
The HLOOKUP() functions are on the report worksheet, wherever you need data from a specified week.
If cell A1 on the report sheet is used to select the week number, and week numbers are in row 1 on the entry sheet, the cell formula looks like this:
In this case a value is returned from the second row of data below the week numbers. (The week numbers themselves are row 1).
To work, the range of data specified must contain at least as many rows as the offset value - see the help file).