Quote Originally Posted by JBeaucaire View Post
The macro given will populate the data into columns C:I, and will fill in the sheet name in column B. The only thing left is the column A which you provided no specifications for. I saw 2000 was in that column in the sample, but no absolute indication where that comes from.


If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
I have 'Solved' this question as it does finish the request. And yes, I do know how it works - I left some specs out because I wanted the framework with which I could tailor the rest of the process since some of the data is confidential etc ... with your explanations of terms etc I am perfectly happy with the outcome, and very grateful for your time.
Thanks again!