On clicking the Submit button pivot table should be generated

Hi All,

Please advise how do I get this done through Macro,

I have attached the sheet for your reference.

Raw data is available in Sheet named as "Table for today".
Step 1. From "Table of today" sheet, first two rows & last row has to be deleted.
Step 2. Numbers in text format has to be converted to Number format. Note: I do not want to select and convert, it has to be done automatically ( No problem if entire sheet gets converted to number format)
Step 3. Pivot has to be generated as shown in Sheet 3.

Please advise how to I achieve above 3 steps using macro

Trying to figure this from todays without success.

Thank you in advance.