Selected Answer
In the attached workbook there is code in the code sheet of the Entry Form and the standard code module UpdateReports. The latter can be dragged into your project in the VBE's Project Explorer window while both workbooks are open (this doesn't move the module but creates a copy). The former is best copied by making a copy of the sheet in your project using the Move or Copy function available from right-clicking on the tab. The code will be copied together with the sheet.
Having copied all code to your project (hopefully, a disposable copy of the same :-)) please start with reading the text I inserted in the Location 10 tab in my workbook. Then adjust the tab and code names of the worksheets in your project accordingly.
Read all the comments I inserted in my Entry Form. Note that, if you ever make a copy of this sheet in the same workbook you need to delete the code behind one of them because two sets of it will interfere with each other.
Continue reading comments I made on some of the other sheets. Then read the comments I wrote into the code. Don't worry if you don't understand everything on first try. It's quite a complicated little project, and on first reading you should aim no higher than to know where to look for answers when proper questions get formed later.
Having passed elementary education in the above way you are ready to start clicking. Make sure that you saved your work so far in a spare copy.
The most inviting button may be the "Update now" button at the top of the Entry Form. It will post all entries in the form and delete them in the form. (That's why I kept a copy of that form in the workbook itself.) When the form is empty clicking on another sheet and coming back to it will insert the current date at the top. This doesn't happen if the form has entries in it but you can change the date manually.
Less inviting but probably more exciting is a click in column A of the Entry form. A drop-down is shown when you click on the arrow, listing all eligible Location sheets. This list is created on the fly and updated whenever the sheet is activated. So, as you add more locations the dropdown will include them. The purpose of this feature is to make sure that there will be no typos in column A. You can use real location names in place of the generic names you have now. (The generic names persist in the code names.)
Posting is done by looping through all locations listed in the Entry form. It could be one, 40 or 400. For each data row the code takes the caption in the Entry form, looks for the same caption in the caption row of the target Location and posts the data there. It copies the cell format from the appropriate cell in Entry form's first row. You set no formats in your sample. I inserted two "Text" formats for the purpose of testing. Whatever format you set in the first row of the Entry table will be carried to new target cells in the Locations sheets populated thereafter.
I thoroughly undermined your planning for the date column. Sorry about that. I know it was a lot of work to enter the dates until 2025. The code in the attached workbook looks for the last date in the column (I deleted some odd numbers below row 43000). If it matches the date at the top of the Entry form data will be copied to it. If that date in before the Entry date the macro will enter all missing dates from the last one found to the current one, and then use that row. I presumed you would want the blank rows even though the case probably will never happen. If the date at the end is in the future the macro will climb up the column until a matching date is found. (That will waste time if there are 1500 rows to check.) If that date isn't found the macro will insert a row at the required place. More relevant, if a non-date is encountered, as might happen when writing 1500 dates, the program will break with an error message.
There will be no error message if an item can't be posted. Remember, the macro looks for the column caption of the Entry sheet among the column captions of the target sheet. If no match is found the program will stop processing that particular line. Note that posting is done from right to left. Each posted data will be deleted. Unposted data will remain. A row with remaining data will not be deleted. Looking from right to left in the un-deleted Entry line you can see exactly which caption wasn't matched - the sheet name is in column A. The program will continue to run and post all those items it can. However, items to the left of the failed one will not be posted even if it might be technically possible.
The system of matching captions makes their sequence or location in the Location sheets immaterial. I suggest that the formulas you want to add be inserted using the same system: Look for the column caption and insert the formula result there. I will do that for you but need more information for which there is no room in this thread. Please, after you digest this solution, work out a new problem and put it in a new question. In this thread we should limit ourselves to getting the code to work that you now will have in your possession.
Edit March 17, 2020 =================================
Another copy of your project is now attached herewith. Please observe the date in the file names.
The table in the Entry tab was removed and replaced by a normal worksheet range while trying to maintain a table's appearance. You can now double-click on the cell below the last existing entry in column A to add a properly formatted additional row in this table. The changes did require many modifications in the code. However, other improvements were also implemented. Modified procedures are dated as of today.