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.