Not sure how to explain this, but im looking to save a lot of manual entry.

ie. sheet1 is fetching its data from sheet2 A1:A1000 and displays the data
all over sheet1 to many different cell positions in different columns/rows.
How do I point to new data from sheet2 B1:B1000 by replacing all the cells
"=+Sheet2!A####" to "=+Sheet2!B####" in sheet1 while keeping the same cell
positions??? Hope it makes sense...please HELP!

John