Not sure why I'm finding this so hard....

Using VBA, I want to be able to import a whole sheet from another Workbook into my current spreadsheet. I know the path, filename and worksheet name of the target data.

I don't know how many rows / columns there are in the table in the target sheet so its fine to copy the whole sheet into a nominated sheet in my current Workbook. All examples I've found on Google assume you know the columns / rows of the target, or prompt the user to type that in. I just want ALL data in the target sheet as it varies.

Trying something like this but not able to do the import...

'Open the target spreadsheet
Set wbkImportData = Workbooks.Open(strTargetWorkbook)
wbkImportData.Sheets(strTargetSheet).Select
wbkImportData.ActiveSheet.Cells.Select
wbkImportData.Selection.Copy <------------ This line throws up an error

'### This next bit of code just doesn't work even if I manually (using ctrl+c) copy the target data to the clipboard
'In my current workbook, select a blank sheet to import the data
Sheets("ImportData").Select
Cells.Select
ActiveSheet.Paste