Looping -import each text file into a different worksheet and insert a chart

I'm a bit of a novice with this, so bear with me...

I have lots of text files with data in them. I need to import each file into a different worksheet within the same workbook. After each set of data is imported I need to insert a chart on the same worksheet (all scales,axis,etc the same for each worksheet).

Now I've managed a code by using the record macro function that does this fine, but only for one set of data at a time. And it means I need to change the sheet number, chart title, text file name etc every time...

I'm sure there is an obvious way to sort this by looping, but I'm not sure how.

Here's my macro. The numbers in red are the numbers that I need to increase by 1 everytime it loops... and I need it to loop around 50 times.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help would be hugely appreciated!