Help with Combining Data from 40 or so Sheets

[squeakums]

I need help combining data onto one master spreadsheet from several spreadsheets. Can I write an array macro that can do this?

For instance, the sheets examples are:

Bain, R.
Ebert, B.

and etc.

On these sheets it has their stat information.

I want the macro to take that stat information copy and paste it onto another master sheet. I need it to locate the same name on the master sheet as well. Anyone know how to do this?

Thanks

 

[Norie]

What do you mean by an 'array' macro?

Code could be written to consolidate the data but we would need more information.

For example, are these sheet names?

Bain, R.
Ebert, B.