I know Excel macros can do very cool things, however can it do the following.
I have about 12 worksheets (all in the same wookbook) that are getting data
from 12 difference worksheets (all in the same workbook). Everything is in
the same workbook. Is there a way to confirm that the formulas that are
getting the data from are pulling from the right cells?

Thanks
Frank