I am trying to create a master spreadsheet with the main sheet providing all
of the data. I would like to copy information so as to display relevant data
on different sheets. For instance, On one part of my master sheet, I have a
Houston section that provides sales figures that have embedded formulas. I
would like to copy that portion of the spreadsheet and copy it to another
sheet, yet still linking them so when changes are made to the main
spreadsheet, it will adjust the info on the new sheet. I am using Excel
2007. Any help would be greatly appreciated!!!

Thanks!