Help - Look up Values accross multiple sheets

I would appreciate anyone's help.

I'm working on a worksheet to summarize values from different tabs onto one sheet.
In the first column I have a date and I need a formula that will find that day's budget for a specific store

It looks like this:
Date Store A Store B
May 01
May 02
May 03
May 04
May 05
May 06
May 07

Now each tab is named with the store Number

Can someone please tell me what formula would I be able to use to locate the number I am looking for, for each specific day by store?

Please send a sample spreadsheet with sample results that you want to see... click on Go Advanced and look for a paperclip...

Sample Worksheet.xls

I hope it attached fine.

On this Sample I'm looking to complete the "Store Summary" Tab with information from the "store A", "Store B".. etc tabs.

I need the Look up to recognize the store as a variable and the date as a variable. The values I want to look up in the Store Tabs range in between M5 and M32 in the "Budgeted Sales$" Column

Thank you in advance!!

Hi tims,

Is this what you are looking for? Just copy the cells E5:F32 to the other stores...

Let me know I interpreted your request wrong.

Thanks,
Dennis