One way is to open each file and MOVE the sheets there to the master file -
Right Click on the sheet to MOVE and then select the BOOK (your master file)
to move it to and the location in that BOOK.

If you want to add the corresponding cells from all sheets to your master
then that can also be done.

"Mark Allen" wrote:

I need to gather information from multiple files that all have the same
layout but different information.

Is it possible to update this information into one master excel file from
the other files???

Regards

Mark Allen