I have a macro that needs to pull numbers off of other worksheets by finding a certain name in column A and a certain country in Row 1 and copying the intersecting cell. I've seen the Intersect() method used before, but i have no idea how it works, or if it can even be applied in this case. I want to pull this data without actually going to the sheet to save time as I already have more than 100 sheets to do this on. Any tips?