Need macro to copy data from 1 sheet to multiple sheets based on certain criteria

So I had a go at your problem. To test run macro "ArrData"

The code is not very sophisticated, lots of copying and pasting. The best thing one can say about it that it works as far as I can tell on your uploaded file.

So see if it fits your needs. A sheet can hold max 4 set of data for a person that is you can have 4 sets of data with the same date. If you wish for more you need to make a bigger template to hold more data.

Alf