I have a number of unshared workbooks all with the same structure but have
been completed by different people. How can these now be merged together
into one file without having to copy & paste the data into the master file?

Thank you.