Visual Basic Macros in excel

I have multiple project reports which each have a number of tabs/sheets. eg. a, b, c, d, e, [url removed, login to view] reports will all be dropped or stored in a folder on the network drive. Eg 'Project Reports Week Ending 1/07/2011'

On a separate Program report (which will be stored in a sub folder, within the 'Project Reports Week Ending 1/07/2011' folder) i want a macro to be written on the front sheet that will capture the first sheet of each of the project reports that are dropped into the folder, and put them in the tabs of the program report.

For Example, i'll name all 5 reports






and the Program Report 6.

and name the sheets for each Report






Therefore i have

1A, 1B, 1C, 1D, 1E,

2A, 2B, 2C, 2D, 2E


6A, 6B, 6C, 6D, 6E, 6F.

and so on

I want it as below on Program Report 6.

6A (that contains the macro), 1A, 2A, 3A, 4A, 5A

I want The format to be kept the same, so if it is changed in Project Report 1, It will stay the same in the Program Report.

I'll be paying $30 only, and will be paying once i know the macro works. I will also need additional support, as i need to submit this to someone.

I would also like to see some examples.

Please no time wasters.


Skills: Excel, Visual Basic

See more: works need excel, Visual Basic Excel, visual b, reports in excel, macro excel, macro e, macro + excel, format excel, excel visual basic, excel reports, Excel report, basic program in c++, excel submit, excel contains, multiple excel, macros excel basic, sheet excel visual basic, excel additional, visual basic week, excel report macro, excel macro program, Excel Time sheet, basic support, example visual basic, macro report

About the Employer:
( 5 reviews ) Sydney, Australia

Project ID: #1118749

Awarded to:


Please see PM for more details.

$30 USD in 1 day
(24 Reviews)