Home

Excel for Mac combining multiple sheets from different workbooks

Highlighted
Aussiejt
Occasional Contributor

I have three different workbook (WB) with multiple sheets in each.  Each workbook serves a different function (WB1. Risk Management, WB2 Pre Trip form, WB3 Pre/Post To Do List) I want to take a sheet from each workbook, so that I get one sheet from each workbook to make a document.  Eg from each Workbook I need the sheet for Canoeing.  Is there an easy way to do this?  

 

At the moment I am looking at having to export each sheet to PDF and combine the three individual PDF files into one.  This is very labour intensive and it means that anytime I update info in the excel workbook I have to redo the whole PDF process. This is not really a viable option long term.

Related Conversations
Anyone good at custom format? Please help
Kaneszc in Excel on
0 Replies
Show Blank or Zero
I_B_C in Excel on
1 Replies
Duplicate Billing
Kay_T1060 in Excel on
0 Replies
formuale help
Gavc1 in Excel on
1 Replies
searching a sheet with a true and false function
Aaron_excel in Excel on
5 Replies
Excel Help - Stacking IF Formulas
MaddieLB in Excel on
2 Replies