Hi Guys,

We get a spreadsheet everyday from our supplier with the status of our
production. These spreadsheets are snapshots of our production (that is the
status change of an order is only shown as the date of the spreadsheet and
not showing the dates the statuses changed for each order)

I would like to Merge all the sheets (This obviously gives me duplicate
entries for the same customer number) so that I have a single customer number
along the rows. While the columns(status) will show the date the status was
date_in_status.
This will be updated on a daily basis with new sheets.

Any Ideas?

Cheers
Albert