Combinig spreadsheets

[pilar4u]

Where I work they have a spreadsheet that is originated to evaluate and audit payroll. Has my colleagues check each line they mark a yes(Y) or a (N) in as a verification mark. Now the powers to be haved ask for us to merge the spreadsheets audited into one. But my issue is we can use a vlookup because their repetitive lines for each employee so there is a Y or a N for each line. But we would like to merge all four spreadsheet based on the y or N mark on each line. I have drawn a blank and can't think. I thought I could do a match and it doesn't work then I tried the following formula but it doesn't work. I have attached the spreadsheets if anyne can help I will greatly appreciate it.

[oeldere]

If you make all sheets the same format, you can use the macro integratie oeldere()

After that I made an pivot table of your data.

I deleted some data on sheet 1 (including the merge sheet) to be able to post it.

See the attached file.

[pilar4u]

Thanks for your help sooo much , but I have one question for you and maybe I didn't explain my self correctly. I attached a better spreadsheet that's clearer what they want is the Y or N Mark in the column A of each tab in the column Trial 1 and then I'm going to bring the sheets in for Trial 2 and I need to the same process. I know it's insane but that's what they want. Thanks again for helping me I see the macro but I just trying to enter that y or comment in column A fore each tab. So they can see that each line was check wheter it was in the first or second trial.