Drop Down Menu inserts Tables

[bprice89]

I am in sales and I have a standard one page letter on one sheet or an excel document to send to clients. I created tables for each possible combination of sale that I do. Is there a way to use a drop down menu to select one of the tables from sheet 2? Do I name each table somehow?

[#2 · Accepted solution]

@bprice89 Assuming (and hoping) you have Excel365 or 2021, I created a mock-up based on your description. Perhaps it will help you on your way. If not, please share a file (anonymised) via Onedrive or similar and paste the link to access the file here. 

See attached.

[#3]

That is exactly what I want to do