Auto adding rows based on dataset

[hedgie]

I receive a data file every day that lists all activity for the day. It comes unformatted and I place that in a worksheet where another sheet pulls that data and makes it pretty. Since activity can vary everyday and often grows throughout the month, I want the worksheet that pulls the data to automatically add or delete rows based on the total rows needed from the data sheet. Is there a simple way to do this?

 

[Larry Haydn]

How do you usually pull the data and do the formatting?
* Using VBA?
* Using a pre-recorded macro?

 

[hedgie]

I udually simply add the data to a new worksheet - simple copy paste.