Hello...
I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly.
For example cell G2 = "=worksheet2!A2" which equals "Tree"...