Vlookup alternative or if function

[username_rand]

I have data in multiple excel sheets in the same workbook. All sheets have the same table but different data as each sheet represents a certain date. The name of shops in the table are chosen from a dropdown list and you can see the full list of shops to the right of the photo. What i want to do is to have a new sheet that has the names of shops and the sum of receipts next to each shop, so i'm looking for a formula that would copy and sum the receipt value from each sheet only if the name of the shop is found in the sheets. I know i could easily do it through vlookup but it would need some preparation and changes to the table format and arrangement so it would be my last resort. The below is only a sample of the data i have. Is there any formula that would help me get this done?

 

[mumps]

You said that each sheet represents a different date. I didn't see any date on the sample sheet you posted. Where is that date located on each sheet?