Append content at the end of same sheet for multiple excel files

[Lakshmikanth_2021]

I have more than 10 files in my folder and I need to copy instructions at the for all 10 files in sheet 1. The data needs to be copied in the same sheet at the end. 

[Bren_Spill]

 Hi @Lakshmikanth_2021 - can you provide some more details? Do you have sample data?

[Lakshmikanth_2021]

Steps I do manually.

I have 10 excel files in my directory with only 1 sheet in all files.

I open each file at a time and copy content at the end of existing data in the sheet. 

and I repeat the steps for all 10 files. 

[Bren_Spill]

You can use a batch macro or the input tool wildcard. Wildcard is easier.

For the wildcard, use a regular input tool and select one of the files in the folder. Then replace the file name with *

For example, if the file path is C:\Desktop\Files\Filename1.xlsx, you would replace Filename1, and the new path would be C:\Desktop\Files\*.xlsx

This will read in all files and consolidate them. Test that and let me know if it works