Setting up connections or references between sheets in different workbooks

Hello

I have 2 complex workbooks on my hard-drive. Each has several sheets.

Book1 is stable and its structure changes rarely. Book2 has a new sheet added every month - they have tab names such as mar17, apr17.. etc etc .. currently up to sep17.

The last sheet in Book1 is blank. I want to copy into it the data from the latest sheet in Book2, (which changes every month).

I have tried setting up a connection (Data / Connections) and have succeeded but I get a very messy table structure appearing, which I don't need.

The other way is just to use cell references, so in A1 of Book1's blank sheet I have something like ='book2location','tabname'A1 (I've not looked up the exact format but think I can find it OK)

Snag is, how do I cope with the tab name changing every month?

Ideas & advice please. Excel 2007

Thanks as always KK

some crafted example ... is welcome