Home

Excel for Mac combining multiple sheets from different workbooks

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.