Bring Rows of excel that have been changed

Hello,

Dear All , i need your help

I have a huge excel database and i need to create a macro which will identify the rows that have been changed for a period of time and bring them in a new spreadsheet.

In other words, to use audit trail and then by checking the rows that have changed to bring in a new spreadsheet these rows with the latest data.

Any idea ??????