Trying to add additional data into a specific row of a table depending on row selected VBA

A poor description in my title so i'll try and explain, I've attached a sample workbook showing what I need help with

I use a macro in Sheet1 to input data into a table in Sheet2

I'm then recalling that data in Sheet3 by typing in the ref number and using vlookup to bring the other data back

I then wish to add data from an additional three cells into the row of the table that matches the ref number being used to recall the data.

I then wish to repeat this on a 4th sheet, again recalling the data in the table on Sheet2 wish should now also include the data added from Sheet3. and then add additional data to the row selected

Not a good explanation I know !!, but I've attached the spreadsheet and typed some notes on Sheet3 and Sheet4 explained exactly what I want to happen

Doing all of this with Macros

Cheers

Chris

Sample 1.0.xlsm