I am new to Excel and helping someone else with their Excel problems.

I did a copy/paste of information from a source spreadsheet to the
destination spreadsheet. The data does not automatically update
when it is changed in the source spreadsheet. I have automatic
setup in both spreadsheets. Is there a macro I need to install
to make it automatically update the destination spreadsheet?


The second problem is he wants to enter a value or select from a drop
down list and have certain cells in the destination spreadsheet
be updated from the source spreadsheet.

Thanks a lot for your help and advice.