I've got a workbook with 10 worksheets. One worksheet uses vlookup to pull
values from the 9 other worksheets. I now need to add another worksheet that
will take data from the first compiled worksheet. It will always get the
information from the same cell and it won't be based on a value. Is there a
simple way to do this?

Hi,

I probably missunderstand, but as stated

=Sheet10!A1

In other words just create a linking formula. If you are going to do this
for a large range the above formula can be copied and pasted or you can use
the fill handle. Or you can choose Copy and then Edit, Paste Special, Paste
Links.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Tia" wrote:

I've got a workbook with 10 worksheets. One worksheet uses vlookup to pull
values from the 9 other worksheets. I now need to add another worksheet that
will take data from the first compiled worksheet. It will always get the
information from the same cell and it won't be based on a value. Is there a
simple way to do this?