EXCEL MACRO with SQL CODES

Read SQL codes from Excel macros spreadsheet that creates a final sheet with results. I need to know the SQL code and process behind how the final result set is created. Once I know how the process comes with the final result set, I can then code myself the process in SSIS. I just need help in understanding the code/process that creates final sheet in excel macros.