copying data to summary sheet from multiple tabs

[Plux]

Hello,
I have a large excel document that brings in data and performs some calculations on that data set for me. I have a summary sheet where it will be exporting that data to. I currently have the row and columns headers for each sheet exporting to the summary sheet like i want. What I cant seem to figure out is how to have it import the data beneath those column headers for each tab i have. The screenshot below illustrates what i am trying to have it do. The data that i am trying to copy to the summary sheet always starts in B115 and has a variable number of columns per sheet. The header of column B5 of each sheet corresponds to the data I have calculated in B115 of that same sheet and C5 corresponds to C115 data etc.

Please Login or Register  to view this content.

example 1.PNG

[Plux]

This image might better explain what i am trying to do
example 2.PNG