Fill a sheet with data from different sheets same workbook in a very tricky way - Vol 2

This post is an upgrade for the request at:
https://www.excelforum.com/excel-pro...ricky-way.html

of which @Marc L provided a great solution for a while ago.

Please Login or Register  to view this content.

I have added additional sheet with the name "EXTRA_DATA". And what this sheet does is recording extra entries in case the 5 slots on any of the sheets, "GROUP " 1 to 3 are exhausted.

And for that matter, the column, "GROUP" on the "EXTRA_DATA" sheet keeps track of the various groups as shown on the sample data sheet.
Then the "YEAR" column also records the particular year that record is linked to (There may be multiple years).

So, with the two columns added, I am looking for a way that I can get the data (from "EXTRA_DATA" sheet merged or attached to the right or corresponding group on the output sheet as shown on the "OUT_PUT_DATA" sheet (NEW REQUEST).

I have been staring at the script for a while now and the only meaningful thing I was able to do was to change :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Which of course produced a result (which didn't get me to smile either).

Could someone please help me out?

Thanks in advance

Cross posted at:
https://www.mrexcel.com/board/thread...vol-2.1181671/




Reason:

To place my problem before more experts