I have a data sheet with 5 columns, one column has a customer ID unique
to each customer.
Another column has a # for the service performed.

I've used advanced_filter to use this to create a new sheet from this
data.
This new sheet has ONE row for every customer receiving the service we
originally care about (97001).

What I now need to do is pull the Customer Identifier (column E) from
the new sheet, cycle back through the original data and get the DATE
from each service that corresponds to that Identifier. Date is in
Column B.

Any ideas?

The final product would have all 5 columns from the first service
(97001), then the next columns would be filled with the dates of all
future services...