Excel: Replacing a Range with another Range

Hello,

I am trying to create a drop down menu with 12 options in it that will replace a range of data with another range of data based on what you select.

E.g.

If c1 = day 1 then:
Range(B1:B165) = Range('BudgetImport'!B1:B165)

I can make the menu, as well as the repeating If statements, the problem is, i am having trouble replacing the data in B1:B165 with the dats from BudgetImport B1:B165.

Any help would be appreciated.

Thank you in Advance
Drake