Thanks, that looks as though it could work but I see that INDIRECT needs all the source workbooks to be open.

I currently have over 20 such workbooks, each with 6 worksheets. So I think that's impractical.

Thanks anyway, I'll keep it in mind.