Tabulate Command Button

[damon_l]

I have a worksheet with 12 different columns and an insert row command button where users can add rows as they input data into the rows. I have created a separate spreadsheet. where I would like to have a tabulate command button that the user can press and it would populate the table with all the data from the relevant columns. Some of the columns in this spreadsheet would be reserved for calculations as such these cells would have formulas that would read from the columns that have been auto filled from the command button. Is there a VBA script I can use for this command button?

 

[damon_l]

To further elaborate, I have attached two screenshots. I wish to copy all the inputted data from columns B, D, G, IK, L and M into the columns in the relevant columns into the 2nd spreadsheet. It would have to be dynamic and also format the table according to how many rows of data the user inserts in the first worksheet.

Any support would be appreciated.