macro which copy to first free row

Hello,

First i would like to introduce myself, my name is Igor, from Croatia, and I work in a CardProcessing company. This is my first but not and least post My greetings to all forum members.

In a last few years i gained a great excel and access knowledge, but i am not a programmer, so I need help.

I have two workbooks book1.xls and book2.xls. Book2.xls each month have some data which needs to be copied to the book1.xls. I managed to record a macro which copies data from book2 to book1. The problem is that i cannot make a macro to find a first free row in a book1, each next month, and not to overwrite data from the last month.

Any help would be very appreciated.
Thanks