Create log sheet from multiple source sheets

[nlee]

I am a beginner to 2010 with just an intro class in Excel. I've been asked to find a way to pull information from source A sheet 1-200 (then source B,C,D, etc) and put this information into a main log workbook on one page (each source sheet = one row of the log). All pulled information from each sheet have the same cell address.
I've played with copy/paste with link, but I didn't know a quick way to change sheet names easily from row to row other than manually and its too much information to this.
Am I on the right track and just need to dig further or are there other alternatives to get the result I'm looking to achieve?

Sorry if this is the incorrect forum for this.
All information is greatly appreciated. Thank you.

[AB33]

Nlee,
It would be easier if you could attach a sample book with a desired result. Do not attach 200 sheets- just 3-4 will do. How many workbooks do you have? Is it just you have a single workbook with 200 sheets?

[nlee]

Sorry I have examples but don't know how to attach them and yes it would make it a lot easier to understand what I'm talking about.
Our company is using a software that is no longer supported. I've been asked to set up everything need to move away from the software.
Basicly, I want to take all needed info from one workbook sheet and have it show up in another workbook all on the same row.

[nlee]

Figured out how to attach!

[AB33]

Please see attached. All you need to do is change these settings to your requirements (these are my setting on my PC). Right Click on each of your excel file
Choose-Properties-Copy the file dir as it is in to these settings.

Please Login or Register  to view this content.

[nlee]

Thank you so much for your help. I will test it out tomorrow.