The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.
@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 @binu_acs shows - use a batch macro for this. don't use dynamic input.