I receive data that is routinely the same, but mixed in a different order nearly every time. What I want to do is have a preset formula that will pull specific parts from the data and put them on the side. For example:

I might be given this data, but only want Jake and Matt's name and data.

Donna 56 67 78 89
Jake 23 34 45 56
Matt 98 87 65 54
Bert 54 43 32 21

So I'd like excel to transfer those Jake and Matt to one side along with their respective data, like the following.

Donna 56 67 78 89 Jake 23 34 45 56
Jake 23 34 45 56 Matt 98 87 65 54
Matt 98 87 65 54
Bert 54 43 32 21

Like I said though, names could be mixed up every time, so I need a formula that finds the Name and pulls it and its data to the side.

Thanks in advance!