Unhide/Hide Cells in table based on selected week

[JumboCactuar]

Hi,
im not sure if this is even possible but im looking for a way to store values in 1 table more than once
in example if this week is selected and values are inputted, after changing the date from a dropdown box the table will clear so i can enter data for the following week.
But i need the old data to be recalled.

Currently i save the worksheet as weekdate and have many files, but instead i would just like to use 1 if is doable.

if date in B2 is changed i want the data (C3:G8) to be stored so it can be recalled at anytime

can anyone provide a solution to this?
much appreciated

 

[JumboCactuar]

was thinking something like this but copy/pasting the same table multiple times isnt really ideal

If Range("A5").Value = 1 Then

 ActiveSheet.Cells.EntireRow.Hidden = False
    ActiveSheet.Cells.EntireColumn.Hidden = False
Rows("13:13").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.EntireRow.Hidden = True


ElseIf Range("A5").Value = 2 Then


 ActiveSheet.Cells.EntireRow.Hidden = False
    ActiveSheet.Cells.EntireColumn.Hidden = False
Rows("12:12").Select
    Range(Selection, Selection.End(xlUp)).Select
    Selection.EntireRow.Hidden = True
Rows("25:25").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.EntireRow.Hidden = True


End If

 

[JumboCactuar]

Bump

 

[JumboCactuar]

Still need help