Setting constraints for retrieving complex data to export to an excel report

I hit a wall with how to set the constraints for retrieving some complex data to export to a custom excel report.

The data is coming from custom surveys’ responses…

-Surveys can be taken by anyone with the survey link- no account required. So I cannot pull data from specific users, only specific surveys.

-Surveys have some questions with customizable choices- multiple and limited choice (customizable by the account admin), so each survey could have different choices/answers.

Does anyone have experience or insight into custom data like this? I can only see it as “possible” data and can’t sort this out clearly.