macro 4track changes between two workbook by coping changes and create history for changes

Hi to all forum contributors,

I have recently faced a problem.I have one workbook (say Entry workbook) where data is entered.I just copies the data from this into another workbook (say Report workbook).The problems now goes here,I have to copy all the data every time into 'Report' workbook whenever there is entry/changes in any cell of 'Entry Workbook'.This is my routine work.My problem is that I cannot use the track changes steps in Excel by following menu of Review tab >> Highlight changes >> Check all options.I get simply the sheet.And I have to compare the workbooks with one another and difference type in excel and I found this tedious work and sometimes copy all the data.

What I want is that I want to copy automatically by VBA/macro only those cells where any entry/changes has been made in cell/s in a workbook of 'Entry' Workbook into 'Report'workbook.I want further to know the changes made in 'Entry' Workbook into a separate sheet of 'Report' workbook.This is similar to known as history.The data is so large that I cannot see one by one as it is too time consuming and tedious work.So,I want only the changes part to be copied in one hand in a specified sheet of 'Report' Workbook and those changes only in a separate sheet to know what are the changes made.

Hope this would be enough.

With Best Rgds,