Copy rows from multiple sheets into a master sheet

[dkace]

Hi all,

I am new here - and relatively new in XL programming.

- I have a workbook with 43 different tabs.

- Each Tab contains a table with same headers i.e. :

Tab1:
row 5 :

A5: Header1 B5: Header2 C5: Header3 D5: Header4

Tab2:
row5:

A5: Header1 B5: Header2 C5: Header3 D5: Header4


Tab43:
row5:

A5: Header1 B5: Header2 C5: Header3 D5: Header4


Now, I want to copy the contents of each row into a master tab with the following conditions:

1. Data are copied automatically after there input in any of the 43 tabs.
2. At the end of the copy an extra cell in the row will include the link to the tab
3. Data in the master tab are written in the empty row and will not overwritten or cells of different rows are mixed.

At the end, the master tab will contain ALL the rows of all 43 tabs with no filtering.

I want to do this only with formulas and not with a VB code.


Do you think this is feasible?

Thanks!

 

[mumps]

I'm not an expert on the use of formulas but I think you will have to use a macro to do this.

 

[My Aswer Is This]

I have serious doubts that you can write a formula to do all this.

 

[estevaoba]

This workbook I found some time ago shows a method and instructions to do what you are looking for.
It's somewhat laborious, but it works.

I just added the column for hyperlinks in the master sheet as desired.

In the end, copy the last tab as many times as necessary and rename them.
When renaming tabs, make sure you don't use special charaters or space.

Download file at this link:

https://we.tl/d2gDMtuAzM

I do hope it will work for you.

 

[dkace]

This workbook I found some time ago shows a method and instructions to do what you are looking for.
It's somewhat laborious, but it works.

I just added the column for hyperlinks in the master sheet as desired.

In the end, copy the last tab as many times as necessary and rename them.
When renaming tabs, make sure you don't use special charaters or space.

Download file at this link:

https://we.tl/d2gDMtuAzM

I do hope it will work for you.

I am eternally obliged my friend! Professional support in not time!

Many thanks!

D

 

[estevaoba]

You’re welcome. I’m glad I could help!