Merging contents of 3 worksheet into a new worksheet

[Carl_London]

Hello good people,

I hope someone can help me. I need to merge the contents of 3 worksheets (Oct, Nov, Dec) into a new worksheet called Total.
Each of Oct, Nov, Dec contain a list of entries (rows) starting at row 5. On each of the three workshet Column A is a unique ID and Column B is a date.

In the Total Worksheet I would to only show the full row for each entry, but only the first date the unique ID occurs.

Can someone help with a formula please, I would prefer not to use VBA.

Thanks

Carl

 

[PeteWright]

Hi @Carl_London

Could you provide an example please?
I'm not sure about the "unique ID" since you wrote "only the first date the unique ID occurs".