Copying all row in multiple sheets to one sheet where each sheet shares unique ID in a cel

Hi,
Been running around internet trying to figure this out.. Im a novice in Excel so apologies if its incorrect vernacular being used.
I have a single workbook with multiple sheets. Each sheet contains the same columns, and are all part of the master sheet, broken up for ease of editing into multiple sheets. Several columns have data inputted, and I would like to copy this data from these sheets back into the corresponding row in the master sheet. There is a column in each sheets which shares a unique identifier in a cell also found in the master sheet. Is there a way to copy several columns of data in a row, by matching the unique identifiers between the master sheet each of the other sheets?
Many, many thanks.
Oisin

Not sure if this helps or not. From what I understand, you're wanting to tell Excel to look for data on a specific sheet and put it on the Master List. It also sounds like each page has a unique identifier for each record. If this is so, you may want to use an INDEX/MATCH formula combo (see attached doc).

If you're wanting more info on INDEX/MATCH, I've found the below link quite helpful:
https://www.ablebits.com/office-addi...ction-vlookup/

A somewhat easier way (for me) to visualize the formulas in combination is =INDEX([column of data with original cell]),MATCH([unique identifier in the new cell's record that is also in the original cell's record],[column on original cell's sheet containing the unique identifier], 0)). Zero will give you an exact match instead of an appoximate match, which is probably what you want.

If I/M is what you need and you are new to this, you will probably find it quicker (especially with multiple sheets involved) to click each of your formula areas/ranges than to actually type them.