Hi All,

Can you help? I have a excel workbook with 100tabs, I need to collect
data from all to put into a single sheet, the data is in a floating
range, it always starts at the same point, is the same width, but can
be hundereds of lines.......

All sets have a different name, in a specific cell... i need to copy
this and replicate down for each line????

I hope that makes enough sense....

Thanks in advance

Craig