This is how I would do that. you seem to have some variations on the individual sheets and the titles of columns and such. There's no need to worry about that, your form can grab the appropriate titles across row 5 in each sheet, it won't matter if they're the same from sheet to sheet. These macros will get the column categories and the dates from the "activesheet", the enter the values into the table accurately as you make entries.
If you select the same date/category a second time, it will add the values together.
Bookmarks