Hi,

From what your indicating the code for this would be tedious.
You need to re think your approach for the desired result.
Do you want to look at column "D" for the names and then look at each sheet for that name and return the data to the search sheet if found?

If you can make it simpler.