make multiple cells in 1 worksheet equal multiple cells in another

[Guest]

I need to assess data that I cut & paste from another format. To do so, I
must make cells in my own worksheets equal the cells that C&P items happen to
inhabit in Excel. I know how to make 1 cell equal another in a different
worksheet, but I have several adjoining cells(both in rows and columns) that
I would like to make equal to several adjoining cells in my own separate
worksheet so I can group and add formulas at my preference, from my own
worksheets. I could enter the simple "=Sheet2!B2" formula, but I have
potentially many hundreds of these cells to add them to.

How can I group certain cells to equal a group of similar cells in another
worksheet?

 

[vezerid]

Select the destination range (a range equal in dimensions to the input
range).
Enter =Sheet2!B2 and press Ctrl+Enter. The formula will be copied
throughout and the cell references will change accordingly.

Does this help?
Kostis Vezerides