Reference or fill series for part of a file location?

Hi, I'm frequently analysing data that involves pulling it from 12 separate monthly files, so a table with data labels vertically and 1 column per each of the 12 months horizontally. I will typica...