Capturing Unique numbers from one sheet to another without overwriting

[PuntingJawa]

Excuse me if my wording is not quite correct. I've tried getting an answer on this question before but it went off track after giving more information than required that made the threads basis on the irrelevant information. With the disclaimer out of the way here we go.
I have a sheet that I am able to generate Serial numbers based on criteria I place in 3 boxes. 3 are changeable "Year" "Month" and "Count" which changes the QTY in certain cells in sequence thanks to =O3&P2&Q2&TEXT(SEQUENCE(R2),"000" formula. This is important. I have 2 databases that I use this with the generate these numbers.
What I am trying to do is Capture these numbers in a log on another sheet. How ever I need it to do the following.
1. I need it to keep only Unique numbers generated. This way if someone is messing around it's not creating hundreds of thousands of these in a log.
2. I need it to move to the next line and not overwrite any data that gets transferred.
I am very new to excel but am learning fast. I don't have the experience with code but have tried a couple and have come close to what I was looking for but kept getting errors. I've also tried pulling the data but it disappears or pulls up more errors so I'm definitely not in my element with this. The locations are as follows if it helps.

Aux Workbook Op Workbook
Sheet1 G to Sheet11 A Sheet1 B to Sheet10 A
Sheet2 B to Sheet11 C Sheet1 D to Sheet10 B
Sheet3 B to Sheet11 E Sheet2 B to Sheet10 D
Sheet4 B to Sheet11 G Sheet2 G to Sheet10 E
Sheet5 B to Sheet11 I Sheet3 E to Sheet10 H
Sheet5 E to Sheet11 K Sheet3 J to Sheet10 G
Sheet6 B to Sheet11 M Sheet4 C to Sheet10 J
Sheet6 H to Sheet11 O Sheet5 E to Sheet10 M
Sheet8 B to Sheet11 Q Sheet5 J to Sheet10 L
Sheet8 E to Sheet11 S Sheet6 B to Sheet10 O
Sheet8 H to Sheet11 U Sheet6 G to Sheet10 P
Sheet9 C to Sheet11 W Sheet7 E to Sheet10 S
Sheet9 H to Sheet11 Y Sheet7 J to Sheet10 R
Sheet8 B to Sheet10 U
Sheet8 G to Sheet10 V
So this is an example of the Op Workbook with the above mentioned generator on Sheet1

Op Mock 4-24-2021.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	No.	Serial No. LH		Serial No. RH	Description LH	Description RH	Rev. A-E	Rev. F-J	Company Name	Part No. LH	Part No. RH				Item	Year	Month	Count
2	1	Serial No. DOL214001		Serial No. DOR214001	Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725	Touch Green Only!			Serial No. DOL	21	4	5
3	2	Serial No. DOL214002		Serial No. DOR214002	Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725				Serial No. DOR	^	^	^
4	3	Serial No. DOL214003		Serial No. DOR214003	Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725	Leave Alone				^	^	^
5	4	Serial No. DOL214004		Serial No. DOR214004	Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725					^	^	^
6	5	Serial No. DOL214005		Serial No. DOR214005	Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725	Is a formulated Cell			These are the only changable
7	6				Door Operator LH	Door Operator RH	A B C D E	F G H I J	Fuji Electric Co. , Ltd.	SP455530	SP456725				Factors. All else is automated.
L1 R1

I need to be able to capture what is generated in Sheet1 Cells B and D to Sheet11 Cells A and B

Op Mock 4-24-2021.xlsx
	A	B	C
1	L1	R1	Date
2
3
4
5
6
7
OP SN Log

Please let me know if this makes sense and is doable or not. I'm essentially at the end of my rope figuring this final piece of the puzzle out.