Hi All,

If you can help it would be greatly appreciated!I'd like to take the sheets ('page 1' & 'page 2') in this excel (attached) and merge them into a master spread sheet ('master')

I know this could be achieved by copy and pasting but ideally the master would update as information was changed in respective pages.

Desired outcome: 'master' spreadsheet that compiles all the information from the two (or more) other pages of the same format so that data can be observed as a whole.

Please help! And thank you in advance.

JoeTest Work Sheet.xlsx