Automatically Changing Copy Range in Macros

In my program I have data coming from an outside workbook. The amount of data coming into my program changes (Additional Rows) could be more or less. What I want is for the macro to recogize the change in data size and copy the new amount automatically. ie Change copy range. I would post the program but it is proprietary.
Thanks