I have an Excel 2002 workbook with multiple worksheets; these represent weekly invoices. I want to summarize the invoices for reporting purpose. I’ve set up the formula to pick up the entries from the the first invoice and now I’d like to copy that formula to pick up the values from each invoice. I can’t figure out how to do this so that it picks up each worksheet, it just gives me the same worksheet name 52 times which I then have to manually change. Is their some feature I’m missing here to turn on relative addressing for worksheets?
