Can someone point me in the right direction?

I have a pivot table that sits in Collections tab (data is below)

pivot.jpg

As an example i'm looking to capture the sum of all Desktops collected within a date range of March the 2nd - 6th and for this to be populated into another worksheet.
Can anyone help me with the formula?

Many thanks