WOw, you are re-inventing the database!
Why not have a DB with an entry form, for entering. Then another form for management of already entered parts? If you have no experience with a DB, the learning curve is way less sharp as with VB. Besides, a DB can scale!
If you decide to go down this route, I will help with design. Otherwise, wait around, and more than likely someone else will author you a script to cut and paste.