2 Sheets - Input Sheet & Output Sheet - Find unique number and add value to a column

Hi

I basically want to automate (using macro) the inputting of certain amounts to a general output sheet using a macro. Here's my sheet and I hope you understand my imaginations

Input Sheet and Output Sheet - Automate.xlsx