Hi Ron,

It would also be useful if I could capture the worksheet name for each
row.

Thanks,

Dan

On Nov 13, 2:31 pm, "Ron de Bruin" wrote:
Hi Dan

I see if I have time tomorrow to make a example for you.

To be sure you want the cells from each sheet that is in each workbook
Am I correct ?

Bed time now for me