Help: Macro to pull categorized data from spreadsheet and assemble into different charts

[Maxamillion]

First off, I'm very new to VB. I'm looking to build a Macro that will enable me to build multiple pie charts based on data I pull from an online database.
The data is turn around times on services for clients and is split into three categories (Priority 1, 2 and 3). Each priority requires that the service be done in under a certain amount of time.

I need to be able to run my macro and be able to produce three pie charts, each with the amount of late vs. on-time services.

I'm unsure on a couple things. First, how do I build a function that can differentiate between each Priority category?
Second, how do I only select relevant data from the spreadsheet (in this case, the TAT column).

Ideally, I'll be able to insert a Turn Around Time Report into excel, run my macro, and three pie charts will pop out, each with the amount of on-time vs. late services.

I've attached an example of a turn around time report. Thanks!