Collating Data Across Multiple Worksheets into One Master Worksheet

[Beese]

Hi everyone,

I have a bunch of spreadsheets where numerical data (reference numbers) has been arranged into columns in multiple worksheets.
Spreadsheet Example.JPG

I've attached an image of my spreadsheet, as I can't seem to upload a file to the forum at the moment.

As you can see in the image, I have a spreadsheet with three columns of data in a worksheet. There are 41 separate worksheets within the spreadsheet, all with data in the same format.

I need an efficient way to combine all the references in all 41 'Column A's into one list. Essentially merging the data from the 41 worksheets into one single worksheet (with three columns of data).

However, I haven't been able to find a means of doing so, and am left with no option but to copy & paste them.

Is anyone aware of a method or function within Excel that would permit an expedient way to collate the references into one worksheet?

More than happy to expand on any aspect of this query, should it not be entirely clear.

Thanks everyone!

[JLGWhiz]

If you just want to make one master copy you could do something like this.

Please Login or Register  to view this content.

[Beese]

Hi JLGWhiz, and thanks for the response.

Sorry to sound awfully dense, but I'm not entirely sure where and how I would place this command script into Excel as a function. Would you (or anyone) be able to point me in the right direction?

Thank you!

Beese