It it possible to change the settings of a formatted table?

At the moment when pasting a new data set into the table, I am having to drag the table down to increase the number of rows before I can then paste the new data in. Once I have done this, I then need to delete any rows that are left at the bottom of the table to avoid my slicers showing blanks etc.

Is it therefore possible to have a setting in the table where I can just paste data into the table and it will resize accordingly to the last row of new data?

I know this is a small issue but I update my data set every day as the table is linked to a Dashboard and Pivot Tables etc.

Thanks