Found the answer, and just a couple question away from mine... Thanks BoniM.
Works like a charm.

"maura" wrote:

We have 10 worksheets in a workbook and we want to create another worksheet
that references 2 cells from each of the 10 individual worksheets.

What is the formula or code we can use to get the information to populate
from each of these worksheets to the new worksheet cells?

Any help greatly appreciated! m.