After macro is created

[Holytuna]

So I pull data from a data base this information may change


My issue is control a then creating a table may change from report to report so when I first do the macro it may have only 100 rows and when I run the macro for another report it may have 150 rows. When running it it will only catch when I did the first report. Is there a way to automatically catch all rows regardless if it has 100 rows or 500 rows of data?