Search, using lists maybe?
 

What I have:

An order form with multiple SKU's and 6 columns for the customer to place
over a 6 month period and then another 6 columns showing history for same
period last year. A simply version of it would look like this:

Customer Number: 12345

July Aug Sep Oct Nov
Dec
His Ord His Ord His Ord His Ord His Ord His Ord
SKU-A 3 4
SKU-B
SKU-C 1 4
SKU-D 3 8
SKU-E

I also have a report (exported to excel) showing sales by product for each
customer on a different sheet. Now to have a single report for each customer
would take far to much time (4000+ customers) so I have all the history data
in a single report.

What I would like to do it somehow create a search, so when you enter a
customer number on Sheet1 (order form), it will sort the data on Sheet2
(history). That way, i will be able to use a vlookup to pull the history into
the order form. Is something like this possible? I would be grateful for any
help you guys n gals could provide.

Thanks
Rob