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?