Trying to impiment a user form with multiple sheet sort and update

[dgclubbie]

I have been trying to simply a spreadsheet that I have had running for years, as business has grown so has the sheet and it is now very slow to use.
I have a transport company and our vehicles are inspected by the government twice a year. This spreadsheet has two parts
Part 1 is the vehicle sheet (now above 30 vehicle sheets) and the inspection data is: date, inspector number, Pass, Fail, certificate number and a percentage of pass/fail. Each of these sheets is named by the vehicle rego number.
Part 2 is where all of the data is compiled to give an over all snapshot of pass and fails handed out by the inspectors. Whilst I have always just manually entered the data, the shear volume of time needed by switching between sheets is becoming quite laborious.

I know its a big ask however I would like to be able to
Part 1 (individual Vehicle sheets)

1. have a user form that place the data in the correct worksheet (Via rego).

Part 2 (master sheet)

1. Check the inspector number(s) and append the inspectors number of pass / fails or
2. Add a new inspector if their number isn't already in the list

I am sure I will have a few other issues to sort with this one, but if I can get that much working I should be able to figure the rest.
Thanks
Darren

[dgclubbie]

I have progress slightly.
I now have the ability to change to the correct worksheet to enter the inspection details by adding the rego number.

I have used the 'exit' statement in the text box to trigger the switch to the required sheet

Please Login or Register  to view this content.

next is to try to insert the date into column A, and to sort into order via the date

[dgclubbie]

Just an update of where I am up to.
I now have the part 1 working. from the master sheet you click the add inspection button and fill in the text boxes with the appropriate data, use 296hoh in the rego text box to show that vehicles sheet (there are about 34 'vehicle' sheets, I have only included one).
There are 3 radio buttons pass, fail and clearance add a 1 to either the pass or fail column, if clearance = true then the row is coloured orange and there is not a 1 added to either the pass or fail as the clearance is just reversing a fail.

Now this is where I an truly stuck.
If you look at the sheet names 296hoh (vehicle rego)you will see some of the inspectors have multiple entries. I want to compile a list of the inspectors on the Master sheet and if they have done multiple inspections add the inspections together but only have the inspector listed once, ie inspector 275 has 3 passes and 2 fails for example. The orange rows need to be ignored as they only correct a fail.
I would love to autosort the entries on the vehicle sheet by date, and on the master sheet by inspector number. if possible I would like to try to avoid using a table for this as I ultimately don't know how big this might end up.

If you can see a better way to achieve what I have done I would also like to hear as this is a learning exercise as much as a way of me becoming lazier
Inspectors pass fail V3.xlsm