Extract Data from 12 different sheets into one single column without VBA and PowerQuerry

12 sheets as 12 months.
I want to copy unique values from these 12 sheets. Sheets name is defined as "months" in NAME MANAGER.
OR how to use {months} name ranges in this formula which is working for only 1 sheet? I don't want to use the same thing 12 times in a single formula that's why i created a 12 sheets and defined it "months" in NAME MANAGER.
OR if someone can provide another working formula because this method will automatically update the new value inserted in any month without refreshing.

Note: this file only have 2 sheets as a sample.
I don't want to use PowerQuerry, PivotTable or VBA.
I created it and using this database since 2013 and it's very complex so i cannot change it's properties.
I did not post same problem on any other platform.
I am using office 2016.

Thanks

I'll ask Belinda's question another way.

Any formula is going to be VERY complicated.

1. Is one helper column per sheet acceptable? EWven if a helper is acceptable...

2. By FAR, the simplest solution is to have ONE sheet, with ONE extra column containing the month. Excel allows for more than 16,000 columns per sheet, so you will certainly have space for it.

??? Confused. Instead of 12 sheets, have ONE with an additional column for month. Look at the January sheet. I have added February in and added in an extra column, for the month. With a big flat slab of data, doing any calculations will be FAR easier. Combining data from different sheets is VERY, VERY messy.

User defined function with VBA code is another option. It does not require any changes. it can be used like any other function. Are you interested.

Does a single list of unique values from all 12 sheets is required.

Your replies are confusing. I do not know what is acceptable and what is not.

Here is the macro for creating unique list .

Please Login or Register  to view this content.

For the list to be corrected when changes are done in any worksheet Worksheet event is to be used for each sheet.
Code for worksheet event is

Please Login or Register  to view this content.

I have applied for Jan Sheet same is to be repeated for all sheets.
How to use workheet event the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm
This is one time job.

Sorry. Here is the file.
The macro will not change any data in any sheet. Change the macro security for this file. There is nothing in macro which changes the file.

Your VBA is very fast and perfect solution for copying unique data thanks and sorry i think i couldn't explain my concern regarding the macro you applied.
As i sent screenshots of my working excel file there are also some more sheets in my working file after 12 months and sheet Style Detail like Credit Note, Ledger, Invoice etc.
So the sample file you sent with macro working fine but when i copy that macro into my personal excel file the macro is working but it is also copying data from other sheets after 12 months sheets and for that for your view i also sent the screenshot in Reply #19 where the code also copied some values from other sheets like date and other values.

2ndly i asked that how can i combine two events into one code because i am already using another event code, for Highlighting the current selected Row.

I hope if i could explain my difficulty. This is the same concern i asked in Reply #19.
Thanks

I have modified the codes
Macro

Please Login or Register  to view this content.

Worksheet event for all Monthly sheets.

Please Login or Register  to view this content.

You can combine worksheet event code with other event code. If you have any problem upload the event codes that is already being used.

Pl post a sample file similar to your file.
In this code A5 is used to know there exists a data in that sheet or not.