Using Excel and Sharepoint files to make a live Reporting Document

Good day,

I can not get power pivot to accept cells in a relationship when I have a new branch in the following financial year without loosing visibility of the previous.

Also I see when creating a pivot table for the matching relationship data only provides me with the column header it removes the Month and the Financial Year it is relevant to.