CHALLENGE -Find matching cell, copy/paste values to last row within column of matching cel

Hello

I am new to macros, but I searched everywhere I could online and have not found a solution to this, or even someone that has asked this question before:
I have a table in Sheet 1. I need a macro that essentially looks up the value in column A of each row, finds its match in Sheet 2, row 2. When it finds this match, it copies the data on Sheet 1 in columns B:D on that specific row, and pastes the data in Sheet 2, to the first unused row of the column that it found the matching value in.
Please see below for a manual visual of what I need it to do:
Sheet 1: Sheet 1.JPG
Sheet 2: Sheet 2.JPG

The above pictures shows what it needs to do, but just automatically via a macro.

Is this possible. Feels like it should be, but I have honestly no idea.

Thank you for all of your help.

J

Attached you will find the test workbook for this scenario.

Hi TMS, Attached you will find the visual aid you mentioned.