Macros needed to process csv files

IN PROGRESS
Bids
12
Avg Bid (USD)
$131
Project Budget (USD)
$30 - $250

Project Description:
I need macro that would do the following:

1. Let me navigate to folder with data to import
2. Select files to import
* Files can be either *.csv or *.txt
* Files are either coma, space or tab delimited
3. Import selected files to one worksheet (either the one which is opened or a new one, doesn't matter). Import each file the following way:
* delimited data imported to two adjacent columns
* if original data is in unicode format, it should be imported as ASCII to avoid problems with Excel importing special characters and recognizing data as text instead of numbers
* add one row on the top of both columns
* put letter "Y" in the cell over the first column
* in the cell over the second column, of given imported file, put the name of the imported file (but without extension)
4. Generate automatically a combined graph for imported data in form of scatter plots with straight lines and without markers, where each "first" column is Y and corresponding second column is X

Some examples of csv files are attached.

Please let me know how fast you can do this job and what will it cost.

Skills required:
Data Processing, Excel, Visual Basic
Additional Files: csv files.zip
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 3 days
Hire mrbrave
$ 74
in 1 days
$ 125
in 2 days
Hire kovmisa
$ 55
in 3 days
Hire DenisSmolentsev
$ 155
in 7 days
$ 72
in 3 days
Hire manishadk
$ 155
in 3 days
$ 210
in 7 days
$ 30
in 1 days
$ 222
in 5 days