Data entry form to populate certain table dependent on validation list

Hi,
I'm trying to create a data entry form/sheet. Where I can select a unit id from a validation list and enter a date and meter reading and then submit the data and it will append to the bottom of a table, specific to the unit selected, in a separate sheet.
I have an example sheet that I would like it to look like, there is only 3 tables in the tables sheet, but my intent is to have a separate table for each unit; 66 in total.

Thanks