Product Tracking Sheet Program?

I made this thread a discussion thread instead of a question thread because I would like hear opinions on how I should do this best. Right now, what I am wanting to do is done with macros inside of microsoft excel spreadsheet and I think a program that is easier to control and perform updates and that did the same thing might be simpler for the end-user and for me. The Excel sheet works fine for right now but editing the macros when a change needs to be made is a pain.

I would like to have a VB program where a user will scan in a serial number and a tester number and then that information will be stored in a sheet, like excel or pdf or something, and then when that sheet reaches the limit of parts that should be on a certain sheet, save the sheet to a specific folder and then print the sheet out.

I will do a step by step breakdown to make it a little more clear what I am trying to do.

Step 1: User determines what kind of part is being scanned (Type 1, Type 2, Type 3, Type 4)

Step 2: User scans the barcode on the part. That data is entered into a sheet as well as the date and time when the part was scanned.Step 3: User then scans a barcode telling the program what station the part come from (Station 1, Station 2, Station 3, Station 4). Then the sheet is saved and waits on another part to be scanned, going back to Step 2.

Step 4: When the sheet meets the maximum allowed parts per sheet, determined by what part is being scanned, the sheet is saved into a folder and the prints itself out.I'm not necessarily looking for code for this idea but more of a 'Well, I would do it like this.." type thing.