How to validate the user, and select the info

Hello,

I want to run a script to first identify the user, and after identifying the user opens a workbook (e.g. workbbok1, sheet1).

user_ID = Environ("USERNAME")

the following is the process
2- Opens the workbook users.xls
3- Check if user_ID is occurred anywhere in column B-E of "Sheet 1"
4- If so extracts the value of A for each instance
5- Opens the workbook main.xls.
6- Checks for the values from step 4 in column A of sheet "data"
7- Retrieve all the matching value rows info into the current workbook (where macro is running from)
8- close all other workbooks
9- let user updates the rows info
10- Update the main.xls with modified information by clicking a button
11- Create a log in event_log.xls stating the user_Id, Date, time and row names that are upadated

I have already coded this, but it is scattered with many errors and not working. I appriciate any help towards this.