auto enter site info from one excel to other excels

[comptechbranden]

I need to figure out if there is a way that I can code a second excel to pull new site info data (like the first five columns in the new row) from the first excel automatically.

We have a main tracker for sites and then other trackers with the same site info but it has other columns of data that makes it get used differently. Any suggestions on how to simplify the data entry with my suggestion? How do I do this???

Thanks for any attempted help. Its really appreciated.