Drop down client list for receiving reports

My question is this; currently I have about 10 customers that when I receive product from them, I do a receiving report. I have ten seperate files, one for each customer, that when I need to do a report, I open the individual file and go from there.

I was wondering if there was a way I can just open one Excel file, have a drop down menu of sorts that I can select my customer from, and when I do it presents me with the appropriate receiving report for that specific customer.

All my reports look very similar, but they all have one or two small things different to cater to each customer.

Does that make sense?

Here is what I was kinda working on/thinking.

On sheet one is where the drop down will be displayed, along with the respected report. I'm using Freeze Pains to keep the drop down visible at the top at all times.

On sheet2 I have the list of customers

On sheet3 I would have the reports for each customer

I would like on Sheet1 to select a name from the drop down in the frozen pain, and have it appear right below in the non-frozen pains.

The drop down I already have made, just stuck on getting the drop down selection to pull up the required report in the unfrozen cells on Sheet1

Any help is much appreciated.

Thank you, I will give this a shot and report back.

Not yet no. Was hoping to attack it tonight or tomorrow during the day.

Too busy at work today to attempt.