pulling data from tables based on criteria

[Dannytt93]

Hello,

I have a workbook which contains a several different tabs all with a different persons stats. i was entering this manually but now i have managed to do an sql dump from the server with all the data i need.

i have created a tab called data dump where im going to copy and paste this from the server and then what i want to do is to create a number of formulas so that it will deposit that data in the correct tab based on the information that is in the table. The data dump table is below and Cell with "Owner" would be B1

[TABLE="width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]Owner[/TD]
[TD]Ticket no[/TD]
[TD]Category[/TD]
[TD]Last Activity[/TD]
[TD]Age Category[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Name 1[/TD]
[TD]12345[/TD]
[TD]WORK[/TD]
[TD]27/03/2019[/TD]
[TD]Less than 30 days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Name 2[/TD]
[TD]246810[/TD]
[TD]Home[/TD]
[TD]22/02/2019[/TD]
[TD]More than 30 days but less than 90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Name 3[/TD]
[TD]36912[/TD]
[TD]Pub[/TD]
[TD]25/12/2018[/TD]
[TD]More than 90 days old [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The table i want to send the data to based on that criteria is :

[TABLE="class: outer_border, width: 1500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Tickets less than 30 days old [/TD]
[TD]Tickets more than 30 but less than 90[/TD]
[TD]Tickets more than 90

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ticket no | Category | Last Actioned | Number of days old[/TD]
[TD]Ticket no | Category | Last Actioned | Number of days old[/TD]
[TD]Ticket no | Category | Last Actioned | Number of days old [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
the lines between ticket no & category etc indicate a new cell - it wont let me put it on the way i have it.

So is there anyway to make it deposit the data for Dan in the tab that says Dan but then split it into 3 categories "less than 30, more than 30 but less than 90, more than 90" and then deposit the data in the correct cell?

So the plan is when i simply copy and paste the data dump from SQL to excel, it will automatically update all of the tables in the spreadsheet?

Any help would be greatly appreciated

Many thanks

Dan