Hel[p me out in this macro

[seemsK]

We have data on 5 sheets .

We need to copy the data and paste on one New Sheet. This has to be done on daily basis. So the rows are different every day.

And the data has to be copied from the 6th row of the first page that is with the heading and 7th Row for all the other pages.

Then we insert column on I .
Then H7 - G7 to get Data on TAT has to be done…….
Then add three more columns after I and the three headings are

<8 for column J
8 to 10 min for K
10 to 15 Min in L


So If column I value is less than 8 min then have A in the cell for column J
If it is between 8 to 10 then A value in the cell of K
And if more than 10 min then Value A in L column.

Then we need a Pivot based on F column which is DEONAME and in front of that Count of J
Then K
Then L

Please see if you can complete the Macro for the whole question if not please do it for the First phase which is adding sheets to one sheet.