VBA newbie here ...

I'm trying to find a way to programatically insert/copy certain cell content
and formats based on wksht name. For example, given wkshts:

#1 Summary
#2 A
#3 B
#4 C

On wksht Summary, column A contains headings (Name, Title, Organization).
For wkshts A,B and C, there are entries for each heading, each entry being to
the right of the previous one. With "Name" being the name of the wksht, in
this case A,B and C entries would be to right of the previous one.

So ideally, when I insert wksht #5, "D," on wksht Summary to the right of
the entry for wksht C, the Name, Title, Organization info from wksht D would
populate on wksht Summary.

Not sure if this is doable but thanks in advance for any assistance.