How To Make Few Dropdown Lists Depending On One Before

how to make few dropdown lists depending on one before.

Example: I have table with next data: COLUMN A: (A1) Expense Type ( in all columns under A1 are types of expenses );

(A2) total trip cost;
(A3) Prize promo tour cost;
(A4 ) court renting cost;
(A5) Prize IPP cost

In columns B1, C1, D1, E1 are cities. Under each city is value for type of expense. I have uploaded worksheet for example.

Now, problem is next: I am trying to make drop down lists ( in new work sheet ) by using depending data from data table.

1.I made drop down list in first cell (let's say it is an A1 cell ) where I can chose city ( for example City of Zagreb ).

2.Then in next cell (B2) I would like to choose type of expense in drop down list ( for example Total trip cost ).

3.Finally, in C3 cell I would like to make drop down list that offers me just expense value for combination of chosen city ( Zagreb ) and chosen expense type ( Total trip cost ).