Multiple search and data return formulas

Hello All,

First time posting in an Excel forum, and would appreciate some good advice to achieve my aim with my spreadsheet.

Sheet 1 contains 7 columns, all with raw data, some columns require date dd/mm/yyyy, some have names, some have numerical quantities with no decimals, some have numerical quantities with 3 decimals. This data is all raw data to be entered by me.

Sheet 2 contains a range of search criteria to extract data from the database in sheet 1. I would like sheet 2 to offer a range of search functions to show data from sheet one. So in its simplest terms, sheet 2, I would select 2 date ranges, and it would then display the data from sheet 1 where these data ranges are met. In its most complex form, sheet 2 may be used to select data between 2 ranges, for a particular customer, between certain price ranges.

I have attached the spreadsheet.

Please advise or ask any more questions if possible.