Excel Macros to import a .csv file into a workbook

Hi,

I need help creating a macro that will import a .csv file into a workbook and refresh the pivot tables, is this possible and what would be the best method for achieving this?


The two files I've uploaded contain some of the raw data (File name: "Data to be imported") that needs to be loaded into the workbook automatically (File name: "Report Template").


Please advise.

Many Thanks,
Tom
Data-to-be-imported.csv
Report-Template.xlsx