Copy/Paste Formula for Multiple Criteria

[quibilty]

I don't have all the tabs included in this file, but in my master file I have tabs for all the names listed in columns A, E, J, & N (for example, "ARI", "ATL", "BAL"...,"WAS" ).

In cell B2 I want the info to represent the info in =ari!O1.
In cell B3 I want the info to represent the info in =atl!O1.
and so on until...
In cell B31 I want the info to represent the into in =was!O1.

In cell C2 I want the info to represent the info in =ari!P1.
In cell C3 I want the info to represent the info in =atl!P1
and so on until...
In cell C31 I want the info to represent the info in =was!P1

The question is: Is there a way I can manually fill out the top row (for all the cells in "ari" tab) and then copy/paste so that the rest of the tabs' info is automatically filled? Or do I have to manually enter each formula??

[Saarang84]

I assume you want a data representation format as shown in Sheet2 in the attachment.

[FDibbins]

It might help if you provided a few sample answers in your workbook?