I have different notepads say notepad1, 2 3 and so on. I have to import data from notepads to excel..

All the notepads are stored in a directory (common folder) after importing data from first notepad, the code has to calculate the end of the row automatically and insert the data from notepad2 to next row and so on..

Also, I need a separate column to say from which notepad the data is fetched (say I should have column to display notepad1 for the data fetched from notepad1)

Appreciate if somebody can help me on this.