Hi Guys.

Please can you assist me here? - been googling for code all week to do this task.
Im new to VBA so still learning by copying code and trying to adapt to different scenarios but struggling with this one!

This my scenario.

1) All files to be fetched will be in folder "Kyle -Path - "C:\Users\KyleC\Documents\ABSA\Kyle"
2) all files will have standard format with header,but i only want data starting at range - C15:Q
3) All files have 4 sheets - I only want MACRO to copy data from 2 of the 4 sheets in workbook ,namely "Recon suspense" & "Recon discrepancy"
4)I want macro to run through worksheet until last populated cell ,copy and paste into master sheet "Summary Master"
3)Master file has 2 sheets - "Suspense updated version" & "Discrepancy recons"
4)Master file has a fixed heading,so data must be copied from range C15:Q
So copy from "Recon suspense" & paste into "Suspense updated version"
Copy from "Recon discrepancy" & paste into "Discrepancy recons"

In short

go to folder path "C:\Users\KyleC\Documents\ABSA\Kyle",copy data on 2 sheets "Recon suspense" & "Recon discrepancy", and paste data (stacked) into 2 sheets "Suspense updated version" & "Discrepancy recons" found in a master file named "Summary master"

Your assistance will be highly appreciated

RegarDs
K