Linking data without using arrays/transpose

I'm enclosing a workbook with same data for City 1 and City 2 for different companies. In sheet7, I want my required data layout structure. How do i link sheet7 with sheets City 1 and City 2 in a manner that any change in source sheets City 1 and City 2 reflect in sheet7. I don't want to use array formula to do that when i use transpose it just copy the data but not linking the data.