Need to write VB macro in excel to copy the set of data with the latest date

Hi All,

I have the data in excel 2007 for devices (different devices), which are updated in different date.
Need to write Vb macro so that rows of data will be copied to different sheet for devices which are updated in latest date

Excel sheet is attached for the reference.