“Ctnl+N” function for new tab but with populated table with data from “input” tab

So my job has a sheet where someone drops data into an input tab for previous day information. They then use the “Crtl+N” function to create a new tab, but the tab has the previous day’s data broken out in a table format with things broken down into particular categories.

So my research has not turned up with any helpful tutorials on how to set this up in a new sheet. Can anyone help direct me to a resource that can show me how to set this up from scratch?