Results 1 to 2 of 2

Thread: Combine sheets with same name from different workbooks into new sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Posts
    181
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Combine sheets with same name from different workbooks into new sheet

    Hi

    I have a folder with many excel workbooks

    Each workbook has multiples sheets - Each sheet is named from A to Z (Sheet A, Sheet B ....Sheet z)
    The header, sheet names are all in the same order and name in all workbooks

    I want to combine all sheets based on the sheet name from different workbooks into a new Excel file

    Example

    Workbook - 1 - sheet A + workbook 2 sheet A + workbook 3 sheet A....etc - as a single sheet NEW Excel FILE A
    Workbook - 1 - sheet B + workbook 2 sheet B + workbook 3 sheet B-...etc as a single sheet NEW Excel FILE B

    Basically I would like to consolidate/merge all sheets with "similar name" from different workbooks in to a new excel file
    So i will have a new excel sheet/file named A which has all sheets named A from different workbooks combined as a single sheet
    likewise for all sheets from A to Z

    Thank you in advance - Any help would be very useful

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,932
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine sheets with same name from different workbooks into new sheet

    HEre is a tutorial on Power Query for combining tables.

    https://trumpexcel.com/combine-data-...ple-workbooks/
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •