Retrieving Data From Various Sheets

[rpreennz]

I am in need of some assistance.

I have a summary tab which I need to pull data onto from other tabs.

I have two variables that I have put into drop downs on the summary tab

One is "branch". Each branch has a separate tab
Next is "month" within each branches tab is a budget for Jan to Dec. From Jan to Dec

I need to be able to select the branch and the month and pull the information from the correct spot.

I have been trying to USE INDIRECT mixed with an H lookup but with no luck.

Any assistance is greatly appreciated.

 

[DanteAmor]

Hi and Welcome to MrExcel.

Could you give an example of one of your sheets (branch)
And another example of how you want the results in your summary sheet.
Can it be with a macro?

 

[rhombus4]

Use code below but change based on your branch and month. All tabs will have to be laid out the same

I.e. sheet2 could be whatever is in your 1st drop-down and the range is your second drop-down

Sheets("Sheet2").Range("A1:A10").Copy Destination:=Sheets("summary").Range("A1")