Macro to copy date related date from one sheet and paste into new sheet

[excelnovice128]

Hi all,

I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want to copy data from the below table into 2 separate sheets:

Sales date	Fruit Sold	Colour	Quantity	Weight	Purchase Price	Sales Price
01-Jan-18	Apples	Red	30	10	10	20
02-Jan-18	Apples	Green	5	15	10	20
02-Jan-18	Oranges	Orange	84	20	10	20
02-Jan-18	Apples	Red	11	10	10	20
01-Jan-18	Oranges	Orange	69	5	10	20
03-Jan-18	Oranges	Orange	17	5	10	20
01-Jan-18	Oranges	Orange	26	5	10	20
04-Jan-18	Apples	Red	23	10	10	20
03-Jan-18	Apples	Red	9	15	10	20
04-Jan-18	Apples	Green	65	20	10	20
01-Jan-18	Apples	Green	1	5	10	20

<tbody>
</tbody>

into:

Apples
DATE	Quantity Sold	Purchase Price	Sales Price
01-Jan
02-Jan
03-Jan
04-Jan

<tbody>
</tbody>

Any help or push in the right direction would be much appreciated!!!

Thanks