I would like to set up an excel file that has several tabs that send data to
one table, but on a daily basis clear the data in those tabs to enter new
info while continuing to add/store that data to the master data table.

First three being, say 1, 2, 3. Data will be entered into those file fields.
I want to be able to send that data to a running summary table ie by rows.
for that day. For day 2 I want to use the same 1,2,3 tabs to enter in new
info and at the same time still have that data linked to that table. etc
continue to clear the entered info but update a master table.

Does this involve macros or can I only do this through controls and database
functions.