Recording advanced filtering macro

Hi guys,
I have report with new data every day. every day I am filtering it to different sheets in order to be able to work with it.
I want to make a template using VBA, that will allow me to enter new data every day and just click a button which will sort it the way I need.

I tried to use advanced filtering and recording it. Once recorded I added a button on the first sheet and assigned it to the recorded macro.

However, when I click the button (without even changing the data- it is still the same data that was recorded), I get the following error:

Run-time error '1004':
The extract range has a missing or illegal field name

I know it is an error that the advanced filtering gives when I have a problem with the range to where I want to copy. But I don't understand why I get this error.
Attaching my attempt.

Thanks,
Niuk

Hi,
I want to take all data on the second sheet (called "copy all data") and filter it to few separate sheets:
On the third sheet ("close") I want it filtered by the "Filter ED" column- only "close" values.
On the forth sheet ("Yellow") I want to filter by 2 columns: "Filter" column (value yellow) and "Filter ED" column (value open) etc.
I am attaching the filtered report (the result I want the code to do).
Thanks

and the file