Downloading multiple tables from UI to CSV

Summary

How to download multiple tables in a single cvs

Content

Hi All,

I have requirement to download multiple table data into CVS. The table structure is as below,

One Parent table.

5 child tables available in under "TABS WITH CONTENT" and another child table next to the parent one.

Additionally one more child table but not available in the UI.

Totally 7 tables(6 visible in the UI & 1 not available in UI but child records present in the respective BO)  

 

The child tables will be refreshed when I toggle between Parent table records. So in a button action, I need to get the current parent and its child related data as separate tables, 7 child tables and one table with one row which should have the selected parent record information. All these in single csv file.