How to automatically copy data from one sheet to another if certain criterias are met

What would be the function/formula to automatically move data from one sheet to another AS LONG AS certain criterias are met?

In my case:

I have one "Master" sheet and 3 other sheets. I would like to get the data from the other sheets columns "G" and "H" IF column "L" has the same number as in the "Master" sheet.

Annotation 2020-01-14 151457.png

So basically if any of the other sheets has the same value in column "L" as the "Master" sheet in column "L" --> Copy the data from the same rows columns "G" and "H" to the "Master" sheets row, where the value in column "L" matches the value of column "L" in Sheet2, Sheet3 or Sheet4.

I hope I wasn't too unclear with this :D

You will need these two formulas. Adapt the formulas to meet your requirement and change the Lookup value in Cell D1 for each new tab.
'Project Master' is a named range in the 1st tab, the address can be edited with the 'Name Manager' in the Formula Ribbon. Pay attention to where the $ signs are in each formula. Remember with any formulas you should only need to edit the 1st formula in a range then drag across the columns then fill down the rows.
1st Row =IFERROR(INDEX('Project Master'!B$3:B$23,MATCH($C$1,'Project Master'!$B$3:$B$23,0)),"")
2nd row { =IFERROR(INDEX('Project Master'!B$4:B$23,SMALL(IF('Project Master'!$B$3:$B$23=$C$1,ROW('Project Master'!$B$3:$B$23)-ROW(INDEX('Project Master'!$C$3:$C$23,1,1))),$A4)),"-")}
The 2nd one is an Array. After any changes to the formula Press Shift Ctrl Enter
To make a NEW tab select the entire 2nd tab by clicking the grey 'corner' above row 1 and left of column A' select 'Copy, click the new 'New tab button' select the corner again and select paste. Change Cell D1.