I have a one master file with a worksheet like below that I send out to
multiple people,it's about 2k rows long:

A B C D
1 40921 John Booked Low risk

2 40922 John Booked

3 40923 John

4 40924 Peter

5 40925 Peter

6 40925 Peter

What I tried doing is copying all the worksheets that I get into one and
using a Vlookup to pull data from columns C and D into one sheet, but with
vlookup it pulls the first piece of data it finds so sometimes I end up with
a blank when I know data is present. Does anyone know of a formula that can
fit my needs?

JS