code to prepare a pivot table from excel file

Dear Team,

Please assist me in sharing a Macro code to create an pivot table automatically.

Thanks and Regards

What is wrong with the method provided by excel?