tony mcpike
New Member
- Joined
- Dec 12, 2023
- Messages
- 3
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
- Web
I have a number of workbooks named A, B, C, D, and E for 5 different areas of the business.
each workbook has 52 tabs (one for each week of the year)
I would like to create a worksheet that if I type e.g. 1 , it will go to all 5 workbooks and automatically transfer in the relevant I data from tab 1 of each workbook so that I can see on one page.
each workbook has 52 tabs (one for each week of the year)
I would like to create a worksheet that if I type e.g. 1 , it will go to all 5 workbooks and automatically transfer in the relevant I data from tab 1 of each workbook so that I can see on one page.