Macro Error for Pivot Table

I can create a Pivot Table for the data I download and it works fine. However, when I made a Macro to do the same thing, I get an error. The error is: Run-time error '5':   The following is a scre...