Is there a VBA code that can look into every worksheet and produce a summary worksheet on certain fields I designate it for.

Ex. Say in Cell B4 It's labeled marketing. Under that cell there are the headings headcount and labor.

To the right of headcount and labor are the amounts. These amounts flow to the right for a 10+ year forecast.

Is there a VBA code that can read each worksheet, know how many people are in marketing, applicable labor, and for that year.

Just trying to avoid linking, if there is a faster way?