Selecting Data Based on User Input

Hi, I'm an amateur programmer and a noob to Excel, so I'm hoping you can help me out.

I need set some cells in my sheet based on user input in a cell (before program runs). Basically, if user chooses 1, B1:B5 needs to match data from H6:H10. If the user chooses 2, the B1:B5 needs to use data from I6:1:10, etc. How can I change which column the data is being pulled from?

Thanks in advance,

famousp