Add Validations Search List - Add Invoice Spreadsheet

Hello, I have an excel spreadsheet that needs some final touches to be ready. I need an absolute expert at working an EXCEL. 1) Need validation search to be added to empty fields under my product columns so that can be easily populated to create the night stock list. Search terms are already in spreadsheet, and someone copied over existing variations but the search list area is not correct and does not include all terms that should be populated. 2) When Quantity is entered for a product by a customer, is it possible to Add a List of those selected products to bottom of Order form on a separate page, like a final invoice right up....? That will show you Description | Quantity | Price , and then of course a Total $ amount. I've attached a screenshot of what I'd like to invoice to look like on the final page... ONE thing- YOU must not mess with any alignment of any row or columns in Sheet 1. Everything has been perfectly aligned, and it took quite some time to get it just right. I'd like someone who can start right away. Thanks.