RFID Tag into excel , Might just be a pivot table or somethiing with acces but im not sure

Hello,
I am new at Excel and do not know how to build what i need,

Every week i need to be able to make a new file and it does not search off of the week before sheet

I am going to have an RFID Reader and an RFID tag it will be a 14 or 15-digit RFID tag on a product and a separate paper tag that will have a 4-digit number on it, that will also be tagged on the product and I want to set up an Excel file that when I scan the RFID tag it will populate it on the sheet and i can type a four-digit number paper tag that will be associated to it

So i want to be able to scan this RFID tag and type in the 4-digit number that's on the paper tag and it saves it and it goes to the next one ready to scan the next one


And i need a place where i can search,
So I want to be able to scan the tag after it has already been put in the sheet and it tells me the number that is associated with it, So if the paper tag falls off i can just scan the RFID tag and it tells me the 4-digit number or it pop up text next to it if it hasn't been entered in the system


Also, i need a separate sheet that will have all the RFID Tag numbers and associated 4-digit numbers in numeric order.

I’m not sure if there has to be some programming done, the rfid reader will either be Bluetooth or plugged into the computer

Any advice would help greatly!!

Thanks for this,
I'm currently using MS 365, V 2407