VBA Excel Macro to Import Many Text files from Single Folder into Excel Sheet in each single cell in bulk

Hello, need small help on VBA Macro code in excel. Task requires to import each text file into each individual cell of A column within Sheet1. Bulk import of text files into Sheet1 of Excel via VBA. Notes: All Text File Names are Different All Text Files are in the same folder There is 815 Text Files in 1 folder Each text file has anywhere between 500 words to 2500 words Each text file's content of 500 words to 2500 words has to be inserted into individual cell of Column A in Sheet1 In other words, we have 815+ articles in text files saved in 1 folder. We need to bulk import all 815+ Articles from Text Files into each individual cell within Column A of Sheet1. You will be responsible to have a small shared screen session with me to guide me to insert your VBA Macro correctly and to show me how to use it on shared screen session remotely.