Thank you!

Works great! I have had to remove the protection from the sheet that it is pulling data from, but this is a minor thing.
Surprised at how super quick this method is in comparison to links! Will have to use it more often!

*added rep*

Jenn x