I need help on vba

[Abdullahorhn]

Hello, ım new at vba, ı wrote a basic macro for my excel.This macro works like this: first he ask me how many company do you want to compare? exp: 3 and then ask wrote a company name and then it writes companies name to my main table and then ı see a value in some cell, so my problem is, there are many companies name in my excel and ı just want to when ı start macro, it write all companies name automatically. How can ı do this. my worksheets names are companies names and in this sheets have some imformation about companies.

if you look my excel you will understand what ı mean.
thanks


here is my excel https://drive.google.com/open?id=1qfM3_XnLO1lH8O_Y9XGQYIokJyzfjwJf

 

[Abdullahorhn]

up