VBA Code to reference one of a recently opened Temp workbook with static Text & dynamic no

HI All,

Relative VBA newbie here, I am posting here for the first time and would very much like some guidance to a niggling problem I have.

Long time member.

Does anyone know how to look for a specific worksheet ("Transactions") in a currently opened temp workbook with a dynamic file name.

I am ultimately looking to copy a specific range into my currently active workbook.

Thanks.

Thanks arlu1201,

Over the years some of the articles contained here have been most helpful.