How to import from website and filter data then copy to desired ws?

[tcambridge]

Hi,

I have the attached workbook, which I have to log-in to UPS website than download data to one tab. Then I have to manually filter the data and then copy to each desired worksheet tab. Then it being link and summarize to the Summary sheet. I just wonder if we can use VBA to automate and expedite this manual process. I love to attache the workbook for your reference but the website keeps giving me error page.
Here is the link to the file:

https://www.dropbox.com/s/1h7c05cllm...late.xlsx?dl=0

The Adjustment tab is for any service fee that is NOT a shipping charge.
Other tabs is filtered data colunms in the data tab.

Thanks for all your helps.