Excel table that adds columns based on date range

Hi,

I have been tasked with improving our spreadsheet from which we manage maintenance periods. It is a sheet where approx. 10-15 end users enter their data into a predefined table. Each user gets their own tab. I will then grab certain data from each tab and populate a "summary" tab, showing the high level info for upper management.

What I would like to do is dynamically (automatically) build a table, with the number of column dependent on the number of days we're shutdown. One "day" is 3 columns, representing the shifts of the day. I would like to automatically add these 3 template columns for each day. Number of days would be determined by putting in the begin date and end date of the maintenance period.

I'm not new to excel, but I am new to vba, which is the route I think I need to take, but I haven't been able to find what I'm looking for with the Google.

What's a good way to accomplish this?

As a bonus: the rows will be for a given project scheduled for the maintenance period, which I would like to add row creation as the end user fills out their data. Again, this would actually be a template of about 5 rows.

The end goal is to eliminate the copying and pasting that has been done in the past to size the table for each department, for each maintenance period. It has resulted in a myriad of formatting issues, formula issues, and other problems that has left the sheet all but unusable. My goal is to create a workbook, where the structure and formatting is managed by me, and the end user only has to enter their data, and not worry about the functioning of the file.

Thank you.