Automatically generating a filtered excel page

Hi everyone. Currently, I am using the below code to find out the total number of cases that satisfy some conditions (B41 is a date).

=COUNTIFS(Data!B$6:B$5494, "<="&B41, Data!D$6:D$5494, "<="&B41, Data!E$6:E$5494, "<="&B41, Data!F$6:F$5494, ">"&B41)
+COUNTIFS(Data!B$6:B$5494, "<="&B41, Data!D$6:D$5494, "<="&B41, Data!E$6:E$5494, "<="&B41, Data!F$6:F$5494, "=")
+COUNTIFS(Data!B$6:B$5494, "<="&B41, Data!D$6:D$5494, "stock", Data!E$6:E$5494, "<="&B41, Data!F$6:F$5494, ">"&B41)
+COUNTIFS(Data!B$6:B$5494, "<="&B41, Data!D$6:D$5494, "stock", Data!E$6:E$5494, "<="&B41, Data!F$6:F$5494, "=")

(Please see the attachment for more details, Thank you )

Now, I would like to generate a "filtered Excel page", listing all details (From A to X) of each particular case, so I can save time filtering each column one by one, and prevent clicking errors that I may make.

Thank you so much for the time to read my question.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

I do not understand how the formula in post #1 relates to the file.
It may help if you could explain in words how the raw data should be filtered so as to yield the expected data.
As to conditional formatting
Black fill with white font: =$J4>=61
Red fill with white font: =$J4>=31
Yellow fill with black font: =$J4<=30
Note that rules should listed in the order above.
Let us know if you have any questions.