I need help pulling data from multiple sheets same column to Summary sheet. What fx?

[CentaurTech]

I would like to use a macro to pull data from multiple sheets with results in summary sheet. Lookup value or match a base number in summary sheet to any sheet named with the same value number. Searching for base number data with extensions. i.e. Summary sheet has value of AG-007909, search matching sheet named AG-007909 and collect data from a single column matching base plus extensions AG-007909, AG-007909-1, AG-007909-2 etc.

[alexander.small]

Hi CentaurTech,

You might want to contact a moderator/admin and get this post moved to the 'Macro' thread. You should have a lot more luck getting help there