Actually, I reckon that I can do it another way:

Open the other workbook. Select the required sheets. Copy them to the master workbook. I've just recorded that macro and it seems to work ok.

The problem was that I was trying to suck them in directly, trying to have something along the lines of Insert-Worksheet From Existing Workbook.