Join workbooks

[ruby]

Is it possible to join workbooks?

I have 3 employees that are using one sheet for each event that they budget
for. Each employee has a different workbook because they have so many
events. Within each employees workbook I have used sheet one to total all
the following sheets to the appropriate budget line. So know I have 3
workbooks with sheet 1 that need to be added togeather to total the budget
for the whole department.

 

[Eduardo]

Hi,
Select 1st worksheet copy and paste it in your summary sheet starting cell A1
Select 2nd copy, go to summary cell A1, paste special,under operation select
Add, do the same with sheet 3

If this helps please click yes, thanks

 

[ruby]

Hi;

I was trying to get away from copying and paste. Looking for something
automatic because the employees can continuously update their events. But
to understand what you are suggesting is that I take a copy of each of my
first sheets in each employees workbook and add them togeather in another
workbook? Thanks for your info.

 

[Eduardo]

Hi Ruby,
I just being able to connect to the comunity, you are correct what I am
suggesting is to copy each first page of your 3 workbooks into the summary
page, or you can have your summary page linked to the other workbooks for
example your first sheet in your workbook is called summary, and the first
sheet on the others workbooks are in Workbook1 first sheet is called s1, in
Workbook2 s2 and in workbook3 s3 so in the summary sheet you can have a
formula summarizing the other sheets

='[Workbook1.xlsm]s1'!A1+'[Workbook2.xlsm]s2'!A1+'[Workbook3.xlsm]s3'!A1

Just change Workbook1 for your workbook name and s1 for the name of the tab
where you have the summary of that workbook, the same with the others