Macro to Copy Information for Each Worksheet

[smmeader]

This is similar to another post, but was a different process so I thought it would be good to start a new one.

I am trying to create a macro that will copy information from each of the worksheets to a "Report Worksheet". I envision the process being:

1. Look at Sheet1, Search Column F (Row 3 and below) for any inputs.
2. If input found (say F7), then copy that value to the "Report Worksheet".
3. In "Report Worksheet" find first unused row (Row 8 and below) and copy the information from step 2 into Column K. (Therefore the cell values of Sheet 1 Cell F7 and Report Worksheet Cell K8 will be the same)
4. Additionally Copy Cell A1 from Sheet 1 to the same row from Step 3 and Column B. (Therefore the cell value of Sheet 1 Cell B8 and Report Worksheet Cell B8 will be the same) - the data will for this step will always be found in A1 on Sheet 1.
5. Go back to Step 1 for next Row (we can set the limit of rows to 100).
6. After it has check 100 rows go to next Sheet (Sheet 2) and repeat.

I hope this is clear, thanks for your help.

See attached file with highlighted cells.