dynamic drop down menu for multiple cells

[Sumu11]

Hi everyone.
I am new to this subject.
This work is a part of order management. I have two excel sheets.

sheet 2.jpg

In sheet 1, column A has a list of products and column B has all SKUs for each product. I have inserted screenshot of sheet 2.
In sheet 2, column D, when I select the product XX in drop down, I would need only relevant SKUs for product XX in next column in same row. I have more than 20 products and each product has at least 4-5 SKUs. So I need to see only relevant SKUs in column E whenever I select product in column D. Please note that product order/ sequence is not fixed.
Thank you very much for your valuable time,
Sumu

[modytrane]

please attach a sample workbook.
It's easier to offer help that way.

[Sumu11]

Thank you Modytrane for the prompt response. The work I am working on is attached.
kind regards,
Sumu

[menem]

(Sorry about my English).

In E3
use this formula in data validation list.

=INDIRECT("Sheet1!M"&MATCH(D3,Sheet1!L:L,0)&":V"&MATCH(D3,Sheet1!L:L,0))

Regards.

[Sumu11]

Thank you very much Menem. It worked.