This is my first time writing a macro, although I took a Visual Basic class before. Any help would be greatly appreciated.

I have several vehicles each in their own tab. In each tab, there are assessments listed, and then equipment in the vehicle at time of assessment. What I need to do is create a way to click any equipment's part number, and search through the entire file to make a list of all vehicles that contained the same equipment, and at which assessment.

Is this something that a macro can help with?

Thanks ahead of time