Dynamic ranges

I have a macro which extracts (the same format of) data from a number of different worksheets and puts this together in one worksheet. In the macro, before the data is written, I clear the columns where it will be written to overwrite data from the previous macro run. I am going to try and set the range where the data is written to be a table and see if this will work, and I can set it as a dynamic range. I might have questions about this, depending if it works or not!