Thread: Auto create links when copy range

I have several existing worksheets in a workbook and want to create a "summary" sheet to show some of the data from each of the existing worksheets. I will manually create this summary worksheet and repeat the following actions: open an existing worksheet, highlight the area (a range) of cells I want to see on the summary sheet and copy over to the summary sheet. I have the following questions:

1. Is it possible to generate links for each cell of the copied area automatically? My goal is to have the changes I make on any of the existing sheets automatically reflected on the summary sheet. This way I only need to perform the manual copy once from the existing sheet to the summary sheet. When I maintain the existing sheets individually, the changes will be reflected on the summary sheet.
2. I know the change of the value of a cell is automatically reflected on its linked cell. Is there a capability to link a range? What I am hoping is to have something like cell merge reflected in the linked range.

Hope I have described my problem/wish clearly. Thanks for help in advance.