Hi Hemi,

Yes, it definitely makes sense. You can achieve this by using the "INDIRECT" function in Excel. Here are the steps to do it:

1. Create a table with all the business units and their corresponding sub-business units. Make sure to give this table a name (e.g. "BusinessUnits").
2. Select cell A2 and go to "Data Validation" under the "Data" tab.
3. In the "Data Validation" dialog box, select "List" under "Allow".
4. In the "Source" field, enter the following formula:
   Formula:

   "=INDIRECT(A1)" 

   .
5. Click "OK" to close the dialog box.
6. Now, when you select a business unit in cell A1, the drop-down list in cell A2 will automatically update with the corresponding sub-business units.

Note: Make sure that the names of the business units in the drop-down list in cell A1 match the names in the "BusinessUnits" table exactly.