Keeping a transfered value the same after changing the original va
 

Two worksheets - worksheet 1 cell A1 has a value (week of the year). I enter
sales for each day S, M, T, etc. Worksheet 2 has 52 seven day weeks. I need
to enter Sales into worksheet 1 week 1 and have it transfer to the correct
week in worksheet 2. When I change the week number in worksheet 1 cell A1
(to week 2), I need the values to remain unchanged in Worksheet 2 Week 1.
Worksheet 1's format remains the same (seven days), however the values change
weekly (weeks 1 through 52). I use =IF(' worksheet1'!A1=1,' worksheet1'!E14)
and get the sales to enter into worksheet 2. When I change the week to week
2 (in worksheet 1) the sales in worksheet 2 week 1 defalt to "FALSE".