VBA code to copy and paste data in one sheet from multiple sheet and loop through

Originally Posted by BadlySpelledBuoy

So you want the results pasted side by side rather in one long list?

BSB

Yes side by side only the numbers as the Column A11:A64 is same for every year. Also if I could add the year headers would be great.