Simple Google Drive automation

Job ID: 32009227

Budget: ₹600 – ₹1,500 INR

This is a simple task
When Name is selected in coloum B4 dropdown the product and ordered coloum should be autofilled based on master data sheet
Suppose select Hotel A then check the output on the screenshot.
If Hotel B is selected then all name under B should appear in the same format
Related categories: Excel VBA Excel Macros Google Sheets