VBA Coded Needed: Auto populate Summary Sheet

[onterio27]

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?

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.