Hello,
I have many worksheets named with client names and in different order from what I see in VB.
How can I copy cell C6 from each sheet into a column somewhere (it doesnt matter)
But the order of worksheets is messed up (On VB Sheet1 is in 3d place sheet2 is in 10nth place ... and so on)
I need the vales to be pasted in the order of which I see the worksheets when I open the file.
Any help is much appreciated.