Read 200 dataset and each one have txt file .

hello everyone I have a project , the Professor give us a 200 excel sheets each sheet has a text file , we need to read all the sheets and make interactive dashboard with visualization , thank you all I hope anyone can help me .