How to set file path (including tab reference)

[cocostar88]

Hello everyone,

I want to create a sheet where one can enter data and that would have a macro that copies the entered data into another workbook. The destination workbook will be in another folder that the source workbbok, and contains multiple tabs that can all be potential destinations. How can I set this workbook to something easier.

I.e. the same thing as this:

Dim fcst As Worksheet
Set fcst= Worksheets("Forecasts")

But that references outside the active workbook.

Thanks you for any help,

Corentin