Hi all,

Pretty new to using macros, but trying to learn fast.

I have access to a couple of files on our company SharePoint site, which I want to extract worksheet data from to import to a workbook on my hard drive. The SharePoint files contain data covering several departments, so I want to extract only the data pertaining to my department.

Unfortunately, each of these files is formatted differently, so I will need to extract each sheet to a separate sheet on my file, and then use an excel function (is this the baest way?) to combine them in to a single sheet.

Can anyone point me in the right direction to achieve this with a macro?

Many thanks in advance

Paul