Macro that Matches Scanned Data

I have a project that takes data scanned in and matches it together as a check in/check out type system. In the example attachment, I need the scanned data in sheet 2 to populate the respective rows and columns in sheet 1. Basically, when a Tray ID is scanned, I need it to either populate row 3 or 6, depending on whether that tray is checked out or not. For example, when a tray ID has been scanned an odd number of times, I need it to start a new row, as it's being checked out, etc. I'm trying to find a macro that either:

• Takes the scanned in data on Sheet 2, puts it in its place and matches it in sheet 1.
• Places the scanned data where it belongs in Sheet 1 in the first place, matching Tray IDs as it's entered.

I sincerely appreciate any insight you can provide for me here.