I have multiple sheets in a workbook. Each sheet is identically setup, I can
get the lookup sheet to point where I want, but I would like to copy the data
from all the sheets to one Master list. I have set up the "list" page how I
want it, and now I would like to just copy the columns and change the lookup
sheet name. How do I copy the formulas to another column without excel
adjusting the cell numbers automatically?