I have a masterfile worksheet that has all the names and catergories listed
in rows/columns.
I have worksheets that have the same information but in column G the
information is populated with the information I want.

What formula/macro can I use to make it so that the information is matched
in columns a-F exactly (numbers and letters) and then the worksheet with
column G populated is populated in the master worksheet. The worksheets are
in several different spreadsheets.

Below is an example:

Column A Column B Column C Columnnd D Column E Column F Column G
Row 1
Row 2
Row 3
Row 4...