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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies