Dynamic Dependent "Data Validation"

I have Master sheet in which 2 Columns like 1. Category and 2. Field Name. ("Master "data)

Category Field Name Updated
DEP-ACCT D1 05-Jan
DEP-ACCT D2 05-Jan
DEP-ACCT D3 05-Jan
TIME-DEP T1 05-Jan
TIME-DEP T2 05-Jan
TIME-DEP T3 05-Jan
DEP-TXN X1 05-Jan
DEP-TXN X2 05-Jan
DEP-ACCT D4 09-Jan
DEP-TXN X3 12-Jan
TIME-DEP T4 15-Jan


I have another tab ("Client to Fill") which has more columns and the requirement is listed below:
It has Category, Field Name, Data
1. The Category has DEP-ACCT, TIME-DEP and DEP-TXN (i can use Data Validation - List and restrict to use these 3 values)
2. Field Name, we need to bring it from Master Data and we need to use Data Validation - List again.
But Limit the Fields Names to be shown in drop down with associated Category.
Similarly, The client will keep adding Field Names randomly against the 3 categories.
So this Field Name drop down list should show the category and respective Field Names to them "automatically" by including new / additional fields.


Like this: ("Client to Fill "sheet looks)


Category Field Name Data to Fill
DEP-ACCT List down (D1,D2, D3, D4) Abc..
TIME-DEP List down (T1,T2, T3, T4) XyZ..
TIME-DEP List down (T1,T2, T3, T4) N1234..
TIME-DEP List down (T1,T2, T3, T4) Vtq..
DEP-TXN List down (X1,X2, X3)
DEP-TXN List down (X1,X2, X3)
TIME-DEP List down (T1,T2, T3, T4)
DEP-ACCT
List down (D1,D2, D3, D4)

I attached the excel sheet to refer.

I can not ask my client to use PQ or VBA. Please share any formula as of Excel 2010 version. thank you.