Index and match multiple returns from multiple sheets

Hi!

I’m interested in doing a sequence of index and match functions to pull all matched entries from multiple sheets. The number of matches in each sheet varies. Right now, I can pull data from each sheet into separate columns, but is there any way to pull from all sheets and list the results in one column? Thank you!

You don't list your version of excel. Please update your profile as that will affect people's response. Also, it's always best to attach a sample file for people to work with and give a better idea of what you're trying to do. You can probably do what you're wanting to do, but it'll help to know the above.