data from various sheets

[rpreen1982]

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.

[JieJenn]

Give this formula a try. In B2, enter this formula and autofill.
=INDEX(INDIRECT($B$3&"!$A$4:$M$7",TRUE),MATCH(A5, INDIRECT($B$3&"!A4:A7",TRUE),0), MATCH(TEXT($B$2,"mmm-dd"),INDIRECT($B$3&"!3:3",TRUE),0))