Multiple Worksheet,Multiple Workbook Formulas

[sharmeen007]

I have 3 Different Workbook which i want to SUM. Example : I want to sum numbers from WORKBOOK 1 + WORKBOOK 2 + WORKBOOK 3 in a new WORKBOOK.
The problem is that i have several sheets on each workbook by dates. example sheet 1 April, 2 April,....30 April and i need to sum from each workbook the same date. Example : Workbook 1 sheet 1st April+ Workbook 2 sheet 1st April+ Workbook 3 1st April in the new workbook on every sheet. are there ways to do this more quickly instead of doing it on every sheet manually?






Thanks in advance.

Regards

Sharmeen

[mikeTRON]

So what i recommend is to always create a processed DATA tab so you can you a pivot table or a sum if formula. How difficult is it to get all the data into one tab?