VBA Autofill a Table Column

Hi,

I'm having a real problem auto filling a table column. I can do it when it isn't in a listobject.table but as the data is being pushed through power query it automatically converts into a listobject.table.

So all I want to do is copy a dynamically changing range of people who are in (Tab Team), paste it into Table Data, column Assigned To and then autofill to the last row (Tab Data).

I have tried using lastrow but it is selecting the whole column and not the populated cells in cells B2:B4 and you will see what I mean when you run the macro Autofill Data on the attached sample.

Anybody have any ideas. I've always played with unstructured data but with 365 and power query it is all coming over to me as tables.