Using drop down menu to pull data

[Ju1cy]

Hi all,

I have a workbook with one master sheet and five data sheets, where all information will be entered.

On the spreadsheet you will see I have a drop down box for the month I would like when that month is selected the data is pulled from the five data sheets to populate the master sheet. So if you chose December, it pulls all data for the row for that month, so target rooms for December added up from each data sheet. I hope that makes sense.

For the life of me I can not figure this out. Please advise on best course of action. All suggestions very well.

I have attached a non sensitive version of the spreadsheet in it's very basic set up.

Thank you in advance

[kasan]

Name of your data sheets can be used as criteria (in INDIRECT() function)
But please note, that names of cities should be excatly the same as sheets names.
Copy this formula to cell B9 of sheet Master and then pull it down and to the right to fill all table.

Please Login or Register  to view this content.

[Ju1cy]

Amazing! Thank you so very much!!!