VBA Code for automating dat from multiple excel sheets to mastersheet

HI All,

This is my first question and i hope you will forgive me as i am new to excel..So my question is that i have one .csv file which has multiple headers (below is the screenshot of it).

Untitled.jpg

So, I have highlighted the cells which i will be using to copy the data from this sheet to mastersheet's (i.e. One master sheet for Location, second for Level and third for tower). However, before copying the data from the source sheet which has above highlighted headers i need to filter them according to pay status i.e. i only need to copy the employee id's which have active pay status i.e. "A" .

The above is for one sheet and then i have around 15 workbooks from which i have to copy the data according to level, tower & location. To conclude i get 1 sheet from one department and another 15 from different department. In short i compare data between these 2 departments.

I Hope above given details helps to understand my concern......