Pulling lines of data from various sheets when each sheet contains a different number of lines


I have a workbook which has a a number of sheets each relating to a different project.

Each project has a different number of milestones and a line for each milestone.

I would like to create a summary sheet that pulls though either every milestone from every sheet or ideally every milestone relating to a defined month (each milestone has a due date rather than a month).

Any help would be much appreciated!!



Edit your submission

Leave a Reply

Your email address will not be published. Required fields are marked *