Is there any way that i program excel to read data from notepad files every time
i open the particular excel file? For example lets say i have created an excel file with 3 worksheets in it. And i also have 3 notepad files with data. Is it possible for excel to link notepad1 with worrksheet 1 and notepad2 with worksheet2 and so on? And ofcourse to read the notepad files every time i open the excel file because the data might have changed.

Thank you for your time.