Auto populate worksheets

Hi, I think I have done what it is that you are asking. Enter this formula into cell A2 on the "LH" worksheet:

Formula:

=IFERROR(INDEX(Sheet1!A$2:A$7,SMALL(IF(Sheet1!$A$2:$A$7="L",ROW($A$2:$A$7)-ROW($A$2)+1),ROWS($A$2:$A2))),"")

then enter it using Ctrl + Shift + Enter (array formula), and then you should be able to drag the formula across and down as far as you like.

I have attached your example workbook with this filled out, just for your reference.

I hope this helps, let me know

EDIT: I have made the conditional part of the formula above bold, to show you what to change to suit the condition(s) that you want met. At the moment, this will display all rows that have an "L" in column A