Dear Experts:

I have the following sheets:

Sheet1 cosnsits of Summary
Sheet 2,3,4... the data extract from accounting software per department
I created a macro to put certain data to Sheet1 and it works prefectly

My question is how can we make a macro that can work eventhough the number
of rows ( range) from data sheets could change anytime.

When I noticed the recording macro it copied to Range "A9", the starting
cell in Summary Sheet, it went down to 20 lines from data sheet1, and the
next it to Range "A 29" if next time it could be 4o lines from data sheet1,
the macro reslut could be wrong because it stil points to Range "A29".

Please help, should we used dynamic copied range from the datasheets?,
bedause in Summary we can make it always go to A9 then End.xldown goes to the
empy cell, something like this?

Frank