Are we talking macros? No Macros
Or only stuff on a sheet? Only data on one sheet
Is the workbook you're gaining access to open or closed? Open
Are you wanting to refer to a range in that workbook, a table perhaps, a single cell? Want to reference a few cells on the sheet.

Thanks for replying quickly!