I have a file that I get from a romer arm that gives me my x, y, and z coordinated of measured points. I am writing a VBA code to pull data from this sheet so it can be compared to other parts that are measured. The excel sheet is formatted like this:

I want to be able to pull the x, y, and z coordinated onto this comparison excel sheet, except the points aren’t always on the same order. Is there a way to pull from my X, Y, and Z coordinate columns based on what the point name is in column 1?