Create an input sheet that can create an output from derived values in 1300 excel files (need to adapt 1300 files) Macros needed

Hi, I need to create an input sheet that can look over 1300 excel files and create an output. These excel files are NBA game. A template page will have to added to the 1300 excel files and some changes will have to be made to them. I have attached 3 screenshots. Of the input. The output. And a sample output that i manually did that isn't complete. The 1300 excel files are in either xlxs or csv. You can decide which format you prefer. Here are the steps needed that need to be done with all 1300 sheets. Note: Empty rows might need to be eliminated. The formulas are already complete in the template page. Theres an xlxs one that needs some debugging and a csv one that works. Step 1. Insert new column in Q in game page. In Q2 make formula = O2-P2. Propogate formula down. Step 2. Insert new column in X in game page. In X2 make formula =IF(AN2=""rebound offensive”,”ORB”,W2). Propagate formula down. Step 3. Copy Template sheet to all 1300 work books. Step 4: From the Input Page take cell B2 and put into either home or away team on template depending on name of spreadsheet. (there will be atleast 82 cases/1300 of that team being in the team name. It will need to be slotted into home or away. for example. If we are studying OKC. and the label is OKC@TOR. OKC is away team TOR is home team). OKC would go into cell H6 of template page. TOR would go into cell H7 of template page. Step 5: From the Input page take cell B8 and put it into both H9 and H11 of the template page. Step 6: From the Input page take cell B6 and put into H10 of the template page. Step 7: From the Input page take cell B4 and put into H4 of the template page. Step 8: Take values from template and put into output page. Remember the template page will have to be applied to all 1300 excel files but will only a fraction of them will be in the output. H6: Column A H7: Column B H14: Column C H15: Column D A19: Column G A13 : Column F A10 : Column E Note: A lot of the time the conditions won't be met in the game. Maybe 10-25% of the games have the situation arise depending on the team. So this will be a sample of between most likely 5-20 in the output I would also like to be able to test different files if need be as well. This means i can add csv or xlxs files into the folder and the macro will work to anaylze them as well. Id prefer csv. In your application please show that you have a knowledge of the requirements. Milestone will only be achieved if work has been done to my sole satisfaction.