This sounds more confusing when I type it out than it is in my head

What I am trying to do is take multiple spreadsheets, all with identical columns, and compile the information into a single spreadsheet.

******authorization&&&&&& 5/13/2015 5/13/2015 XXXXXXX XXXXX Date Entered Primary Care


This is an example of what a line would look like. What I am trying to accomplish is a way to import sheet of these (maybe 10-20 rows, each different) each day of the week. I would like the spreadsheet to mark the date a specific authorization appears on the spreadsheet, but for future days it shows up not change this date. Ideally I would have it mark a date it was 'removed' from the list when an authorization number is no longer in the daily sheet being imported.

Basically someone handling business is not giving us sufficient date on their timeframes and we are trying to track it ourselves.

Any help would be great!