VBA copy/paste range based on two dropdowns

Also posted on mrexcel.com - https://www.mrexcel.com/board/thread...downs.1199727/

I have 2 dropdowns and would like to copy/paste different ranges based on selected values from the dropdowns (I know how to copy/paste but not based on dropdowns).

First dropdown values:
-BD
-AO
-LM

Second dropdown values:
-UFH
-PEX
-MLC

Ranges:
BD UFH = Sheet10 B2:C10
BD PEX = Sheet10 D2:E10
BD MLC = Sheet10 F2:G10

AO UFH = Sheet11 B2:C10
AO PEX = Sheet11 D2:E10
AO MLC = Sheet11 F2:G10

LM UFH = Sheet12 B2:C10
LM PEX = Sheet12 D2:E10
LM MLC = Sheet12 F2:G10

Any tips on how to do this?
Thx

Lots of ways to do this, attached may help.