Combine multiple sheets into one

[AmishNinja]

I have been using excel for years but have no official schooling or training. I am wondering what formula/functions would be best suited for a work task.

Basically I have 5 excel lists that I export from a work site. I do a new export of each of the 5 lists weekly, and changes in the list may occur. Each list may have 100-1,000 columns, but they will always have the same number of rows. In each export, I add a row and put which export the column comes from in the added row.

I would like to create a master sheet that then combines all the lists into one, with my added row so I can see the original export each column comes from.

The problem I am having, is one week the 1st export may have 100 columns, and the next it may have 200. Is there a formula I can use on the master sheet that would essentially pull cell information from A:A of export 1 until it reaches the end of export 1's data, then seamlessly move unto pulling data from export 2 until it reaches the bottom of that export and so on.

Thanks in advanced for the help!

Edit:

I've uploaded an example excel. If you would imagine the "export" tabs are pulled from the work site and the "Export Origin" field is then added to the export data. The "Master Sheet" tab is where I would want the combined info. What I'm looking for is a way for excel to pull the data from "Export 1" then recognize when it reaches the end of that exports sheets data and move onto adding the data from the next export below it. Keep it mind the number of entries in each export will change each week when I pull a new export

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

ALSO>>>> A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

[Glenn Kennedy]

Just 5 rows, 3-6 columns (variable number), 3 sheets will be sufficient... but show what you expect to see.

[AmishNinja]

Apologizes and thanks Glenn!

[Glenn Kennedy]

No worries... no-one reads the rules when they sign up!! Eventually, we force you all to read 'em...