Dear Experts ,

I am looking for help on a code that will do the following:

First Insert column A in the worksheet and copy sheetname in the column A
then
Find the row number of text AAA in column B
Find the row number of text BBB in column B

Copy all the rows in between (Excluding row of AAA and BBB) and paste it in a new sheet called summary sheet and do it for all the sheets in the workbook
Best Regards/VKS