In Excel 2007, I have several worksheets within the same workbook that all
have the same format. I have a summary worksheet in the same workbook that
takes some values from each worksheet. I am taking values from the same
cells of each worksheet and placing them in my summary worksheet The summary
worksheet has a summary of worksheet b in cells A3:N6, a summary of worksheet
c in cells A7:N10, etc.). When I add a new tab, is it possible to copy the
format and values from one of my current "summary rectangles" and paste it so
that the new "summary rectangle" has references to the same cell numbers but
a different tab?