Filling a range of cells based on a cell in another work sheet

Hi All,

I am new so please forgive me if this has already been answered.
I am trying to fill a range of cells based on an input in a cell in another work sheet. Is this possible, I do not want to put a formulas in the destination cells because the range to be filled will change and I also do not want to lose the formula should some have to change the destination cells.

Thank you in advance

I have attached the files. I am trying to add the prices from sheet one to sheet 2 on the prices row. The range is supposed to match the dates I entered on sheet one.

Thank you

Thank you so much it works!!!