Hi, I'm trying to figure out how to copy data in a summary tab that is currently in a row format into other sheets with each row of data in its own column. The macro should know which tab to copy the information to based on the tab name.

I can get it to copy into the other tabs but it just keeps overwriting the same column

I've attached an example of what I want it to end up looking like.

Thanks in advance!