Matching cells with sheet name

[benjibolo]

hi guys,


i have some data which i need help in matching it with which sheet it comes from into a master copy. All the data comes from column D and i need to match and combine all the data together into Column A of a master copy and have their corresponding sheet name on column B.

thanks for ur help in advance!

Example:

a sheet 1
a sheet 1
b sheet 2
b sheet 3
b sheet 3
b sheet 4

 

[AFPathfinder]

Unless the sheet names are listed in your reference tables, I think VBA is the only solution to pull sheet names.