VBA (Visual Basic for Applications is a special programming Language that allows an advanced Microsoft users to create customized programs within Excel and Access. This program is not an add-on , but part of these programs
Power Pivot is an add-in for Microsoft Excel that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build Pivot Tables and Pivot Charts.
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution. This solution can be used in conjunction with Power Pivot