Creat macro

I am in need of a macro to be created in Microsoft Excel. The macro should have the primary function of generating reports with moderately complex data. The macro should be efficient and capable of reporting high-quality data. It must be able to handle large sets of data without difficulty, as well as manage queries to quickly and accurately generate the desired report. I would also like the macro to be documented so it can easily be customized in the future if necessary.