Getting list of tabs of a workbook macro

Hi,
Me again.... As usual I need some help with the macro here...
I would like to get a macro which will return me the list of tabs (Name of tabs) in a workboook named xxxx.xlsx in a workbook sheet (Sheet name- MOM) in which my macro will be running.

Can you please help me?

i may be using this macro to get the data for 7 workbooks situated in 7 different locations. (For your info)

Here's an example VBA you can list the tabs

Please Login or Register  to view this content.

But i am not seeing any workbook path and file name to put in this macro to use in different workbook...

I will need to get the list of tabs of a workbook in my master tracking file

you use it like a UDF except it is a procedure. the default workbook is active workbook unless you specified the workbook name. The list the tab names in other workbook other than active workbook, the procedure will look like

Please Login or Register  to view this content.

Hmm.... i am not sure about UDFs and all.....

Let me explain you my need....

I have a tracker workbook in which I will be tracking all the things like number of defects, action items etc...

Now I would like to add the last mom date also. But the problem is, my 7 projects are using 7 defferent workbooks in their respective locations (Network folers). Each of these workbooks will have different tabs with the tab names as date in which the MOM was made.

So after getting the list of those tabs in 7 different columns (Dedicated for each projects)in sheet 2, I will use MAX formula to get the latest date in which MOM was made for each projects

Did i make it clear (or confused you?)

Ultimate Tracker-for upload.xlsm
This is the tracker I am using now
But it is slow (I Think) and returns the tab names which consist of a tab name 'Tab Name'

Will this help?
Sorry, I didnt add this file earlier

Any help.....