VBA Code to list values in 3 text boxes from 2 sheet depends upon 3 list box values

Hi experts

i have 2 set of matching total profit from sheet (Green and Orange)

i have userform i need vba code to execute these actions

need to validate Drop down list that covers two correspoding columns for listbox1 and 2 for 3

if i select region = ASIA In Listbox1 then listbox2 show all unique values towards ASIA, then
if i select country= CHINA in Listbox2 then Llistbox3 show all unique values towards china
in listbox3 show all Order ID ,then what Order ID select in , result should pop up in both side 3 textboxes green and oranges

Listbox1 Unique column of B:B
Listbox2 Unique column of C:C
Listbox3 Unique column of A:A depends upon Order ID , Result values will be shown in 3 textbox of green and orange becoz order id reflect in both sheet

check sheet view to understand my requirement
click_G for userform

Thanks and regards

Thanks for all experts great code experience solved!!!