Create a new table (or matrix) from an exported set of data from a website.

Hello friends,

I have a set of exported data from a Project Management SW (activecollab). The result is an excel .xslx file with a table inside with a lot of cells I am not going to use. Additionally, what I would like to do is creating new tables on other sheets that use only the data I want from the export. For example, I have two projects and three employees. I want to create three tables with the names of the three employees. In each table I want the tasks done by them and the time they will spend on them in order to create a Gantt chart. I need a solution that allows me to create new tables with selected data from a bigger cluster (the export).

Many thanks, you do not need to give me the exact solution, I only need to know whether it is possible or not and where could I get the info to do what I want.

with macros it is possible to automate it, send a nonsensitive sample of the data and the expected result so we can guide you.