Delete row in linked Sheet if Master Sheet row is deleted

Hi I have a list in Sheet1 like

A B C D E // B AND C ARE MERGED

1 Apple Summer
2 Oranges Summer
3 Banana Winter
4 Mangoes Winter
5 Grapes Autumn

and in Sheet2

A B C D E // B and C are merged
__________________________________
Summer
___________________________________

1 Apple
2 Oranges

_____________________________________
Winter
_____________________________________
1 Banana
2 Mangoes

________________________________________
Autumn
________________________________________
1 Grapes
________________________________________

The Sheet2 cells in B COLUMN are to be linked to Sheet1 Column B for the groups Summer , Winter , Autumn.

When a row is deleted in the Master sheet Sheet1 then the Corresponding Sheet2 rows should also be deleted , but they should not go into the other groups space. ( eg Winter fruits should not go into Summer etc)


Please help

regards

sanjish

I try to understand what you want to do and create a sample.

1. You may add on sheet 1 and the result shown in sheet 2
2. You may delete row on sheet 1 and the result will change in sheet 2