Here, try this.
This would check value in each sheet in B column. Then if something is in corresponding G column it will coppy all needed data.
That means for each name (For example B11) you must not have blank in G11.
rather that going to every second row.
Is this OK?
Bookmarks