Hello,

I've been searching for VBA code for a few days now to implement the following into to my workbook.
A description of the document:
The document contains three checklists, each of them on a different worksheet. The fourth sheet is supposed to be a general summary of those three checklists compared to eachother.
Now I have made it so that within each checklist I can add new rows by using buttons. I do not want all the checklists to have the same rowcount as it would make the checklists unclear.
Each checklist has the same categories but by adding rows within each category the rowcount of the checklists will differ from eachother:
Checklist 1 – Checklist 2 – Checklist 3
Category A - Category A - Category A
Input--------- Input--------- Input---------
Input--------- Category B - Input---------
Category B - Input--------- Input---------
Input--------- Input--------- Input---------
Category C - Category C - Input---------
Input--------- Input----------Category B
…………………………………………………………;

The question:
First I want to create a Macro on the fourth sheet that will copy-paste all the values between each category from each checklist on the fourth sheet (I will put enough rows on the fourth sheet to copy-paste all the data).
(Later on I will link the rowcount of the checklists in the summary sheet (but for me that is not important right now).
As the rowcount differs:

-I need to search for each category on each sheet
-copy the cells between the current and the next category
-search for the same category on the summary page
-paste the copied data

Any help would be greatly appreciated!

Kind regards,

Kupke1987