I have already produced a similar document for a client, allowing "wildcard" searches from a database that copes all possible matches to a new sheet from which the User selects which items to pick. The code puts the selection into an incrementally-numbered Pick List that the user can preview and print and which saves automatically as a new worksheet.
I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting.
Normally I provide samples to let you judge my Excel skill for yourself, but as you made this a "restricted" project I can't send an attachment unless you send me a Private Message first.
Happy to work under a Confidentiality and Non-Disclosure Agreement if required, and will start as soon as you pay the Milestone into the site.
You have not said when the work has to be finished?
I have allowed five days to complete the project, so that you can view the work in progress and make any changes you want in that period.
Hope you find this of interest and look forward to hearing from you
Bob Allen-Turl