This is getting frustrating! I've got a series of summary tables on one
page. Each table is taking data from the exact same locations on other
sheets (that is, one table will use Sheet1!B3, and the next table
Sheet2!B3). But each time I try to copy the summary table down the page,
hoping to simply change Sheet1! to Sheet2!, the B3 reference will
automatically update the number of rows I've copied down, and B3 is now B7!
I tried Copy>>Paste Special (Formulas), but I keep getting the same update
frustration! Any help?

Ed