Just been asked to try and automate a sheet (having only ever used excel formulas a bit before - never any automatic data pulls).

As it stands there is a spreadsheet on a SharePoint with the data on that I need, I filter it to what I require, then copy and paste it to the spreadsheet I want on a different SharePoint page.

Having just been given the csv file address the original sheet gets its data from, can anyone point me in the right direction to get this data imported and filtered to my sheet without me having to manually copy and paste the data


Thanks in advance...