@Akeelah yes, this is possible
first use the input tool to pull sheet names only then apply a filter to remove the unwanted and then use Directory tool to read the required.
@Akeelah sample workflow attached
just use a batch macro. as @binuacs shows - use a batch macro for this. don't use dynamic input.