Sequential Numbering based on multiple criteria

Hi,

I want to create document numbers via a userform that takes input from comboboxes that use vlookup to create the truncated document name. I then want to be able to paste all those inputs (the comboboxes and the document name) into a sheet.
The numbers need to be sequential based on multiple criteria preceeding the number i.e. only if the exact crietria preceeding the number is the same will it go from 000001 to 000002

I currently have 6 comboboxes from which I choose the data I want to include, these are referenced from seperate sheets and using the name manager and 'RowSource' in the properties panel, I can fill in these boxes like data validation.

The DOC NUM (Me.label.8) tab is the following code

Please Login or Register  to view this content.

So it uses vlookup to get the acronyms for the relevant parts of the combobox selections e.g General would be 'GEN' and then creates a document name from it. The Me.Label12.Caption on the end is meant to be the document number. This is the part im struggling with. If the sheet is empty, it needs to start the number off at 000001 and +1 every time the document name is exactly the same. If any of the criteria that make up with document name change these would still be 000001

e.g
ABCD000001
ABCD000002
ABCD000003
ABDC000001
ABCD000004
ABFD000001 etc etc

Also, I was struggling to get the label to auto-update the document name. I need to physically click on it to update it. Same with the document number. Any help is appreciated.
Capture.PNG

I should say that comboxes 1-5 will get inserted into columns 1-5 and the document name into column 6 like so

Please Login or Register  to view this content.

The extension column will be hidden and the document num will only be used to fill in the last part of the document name